m (refresh SMW properties) |
(Better example) |
||
Line 8: | Line 8: | ||
}} | }} | ||
|return=will return the exact same results as [http://php.net/mysql_free_result mysql_free_result]. | |return=will return the exact same results as [http://php.net/mysql_free_result mysql_free_result]. | ||
− | |example=<nowiki>$smcFunc['db_free_result']($request);</nowiki> | + | |example=<nowiki>$result = $smcFunc['db_query']('', ' |
+ | SELECT something | ||
+ | FROM {db_prefix}a_table', array()); | ||
+ | |||
+ | $array = array(); | ||
+ | while ($data = $smcFunc['db_fetch_assoc']($result)) | ||
+ | $array[] = $data; | ||
+ | |||
+ | $smcFunc['db_free_result']($request);</nowiki> | ||
}} | }} | ||
<noinclude> | <noinclude> | ||
[[Category:Database Functions]]</noinclude> | [[Category:Database Functions]]</noinclude> |
Revision as of 11:53, 4 November 2012
Usage:
$smcFunc['db_free_result'] (result)
Description: Works exactly as mysql_free_result. Frees the memory used by the resourse $result.
Parameters:
- result a query resource as returned by db_query.
Return: will return the exact same results as mysql_free_result.
Example:
$result = $smcFunc['db_query']('', ' SELECT something FROM {db_prefix}a_table', array()); $array = array(); while ($data = $smcFunc['db_fetch_assoc']($result)) $array[] = $data; $smcFunc['db_free_result']($request);