Db fetch row: Difference between revisions From Online Manual

Jump to: navigation, search
No edit summary
m (refresh SMW properties)
 
Line 16: Line 16:
list ($first_message, $last_message) = $smcFunc['db_fetch_row']($request);</nowiki>}}
list ($first_message, $last_message) = $smcFunc['db_fetch_row']($request);</nowiki>}}
}}
}}
<noinclude>
<noinclude>
[[Category:Database Functions]]</noinclude>
[[Category:Database Functions]]</noinclude>

Latest revision as of 16:39, 11 October 2012

Usage:

$smcFunc['db_fetch_row'] (result)


Description: return the exact same results as mysql_fetch_row. Frequently used when is known the query returns only one row of data.

Parameters:

  • result a query resource as returned for example by db_query

Return: an array of the values obtained from the query

Notes: emulated while using SQlite with smf_sqlite_fetch_row.

Example:

while ($row = $smcFunc['db_fetch_row']($request))
	$toDelete[] = $row[0];

Example using the function list:


list ($first_message, $last_message) = $smcFunc['db_fetch_row']($request);



Advertisement: