(Created page with "{{:User:Emanuele/smctemplate |usage=$smcFunc['db_query'] (identifier, query, values, connection) |description=Works Similar to how db_query worked in 1.x versions |parameters= *'...") |
No edit summary |
||
Line 1: | Line 1: | ||
{{:User:Emanuele/smctemplate | {{:User:Emanuele/smctemplate | ||
|function=db_query | |||
|usage=$smcFunc['db_query'] (identifier, query, values, connection) | |usage=$smcFunc['db_query'] (identifier, query, values, connection) | ||
|description=Works Similar to how db_query worked in 1.x versions | |description=Works Similar to how db_query worked in 1.x versions |
Revision as of 20:35, 12 April 2011
db_query
Usage:
$smcFunc['db_query'] (identifier, query, values, connection)
Description: Works Similar to how db_query worked in 1.x versions
Parameters:
- identifier - is used for identifying specific queries that will be handled specially.
- query - is the actual query
- values - array of values...etc. (optional if no values used in the query)
- connection - database connection (optional)
Return: a query resource or false on error.
Example:
$result = $smcFunc['db_query'](, ' SELECT poster_time FROM {db_prefix}messages WHERE id_msg = {int:id_msg} LIMIT 1', array( 'id_msg' => $user_settings['id_msg_last_visit'], ) );