db_query From Online Manual

Jump to: navigation, search

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'],
			)
			);



Advertisement: