More Options

Using alias

With SQL, an alias name can be given to a table or to a column. This can be a good thing to do if you have very long or complex table names or column names.
Simplified DB doesn't require you to write query so you don't really needs it but sometime you may wants to shorten the column name or table name.
Simplified DB adds backtick (`) character by default to column name and table name so that it will not throw an error, if you had accidently used some reserved Mysql keywords as your column name. Therefore, to use alias, you needs to first set this backtick (`) character to empty string and then you can use alias Example
            $sdb->backticks="";
            $sdb->dbSelectJoin(array("users as u", "user_roles as r","user_blogs as b"), array("u.role_id=r.roleid","u.userid=b.userid"), array("LEFT JOIN","RIGHT JOIN"), array("firstName as fname","role_name as role")); 

Using fetch modes (Only for PDO)

Only in case of PDO, we are returning array, so this option is available only for the PDO. You can define which type of array you want as a result of select query. For example
 
         $sdb-> fetch_mode="NUM";   // it returns numeric array 
$sdb->fetch_mode="OBJ"; // it returns object array
$sdb->fetch_mode="BOTH"; // it returns both numeric and associative array
$sdb->fetch_mode="ASSOC"; // it returns associative array(default).

Return Single Row(Only For PDO)

If you wants to get only single row from select operation result instead of all rows, you can set $single_row=true. $single_row returns single row of select query operation if true, else return all rows.
 $sdb->single_row=true;//it will return single row from select operation