2) simple_select - Used to perform a simple select query (with no joins) on a table
string simple_select ( string table [,string field(s)] [, string conditions] [, array options])
Builds a simple query, then sends it off to $db->query().
The table name to be queried.
Comma delimetered list of fields to be selected.
SQL formatted list of conditions to be matched.
List of options: order by, order direction, limit, limit start
Returns a resource on success, or FALSE on error.
Example 1. $db->fetch_field() example (in 1.4.x)
global $db; $query = $db->simple_select("settings", "*", "name='boardclosed_reason'", array("order_by" => 'name', "order_dir" => 'DESC', "limit" => 1)); $settings = $db->fetch_array($query); /* Outputs: Array ( [sid] => 6 [name] => boardclosed_reason [title] => Board Closed Reason [description] => If your forum is closed, you can set a message here that your visitors will be able to see when they visit your forums. [optionscode] => textarea [value] => These forums are currently closed for maintenance. Please check back later. [disporder] => 2 [gid] => 2 ) */ echo "<pre>"; print_r($settings); echo "</pre>";