No edit summary |
|||
Line 8: | Line 8: | ||
|values|d3=array of values...etc. (optional if no values used in the query) | |values|d3=array of values...etc. (optional if no values used in the query) | ||
|connection|d4=database connection (optional)}} | |connection|d4=database connection (optional)}} | ||
|example= $result = $smcFunc['db_query'](''', ' | |example= $result = $smcFunc['db_query'](''', ' | ||
SELECT poster_time | SELECT poster_time | ||
FROM {db_prefix}messages | FROM {db_prefix}messages |
Revision as of 10:03, 14 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'], ) );