note 15546 deleted from function.mysql-free-result by philip
| From: | philip@php.net | Date: | Thu, 29 Nov 2001 08:54:38 +0000 |
| Subject: | note 15546 deleted from function.mysql-free-result by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-21419@lists.php.net to get a copy of this message | ||
Fairly straightforward. I don't use this very often at all, but when I have intensive
programming after retrieving data from a database, and the next SQL statement isn't for many,
many lines, or on the page at all, I will use it. You won't notice a difference, but it does
help.
example:
$sql="SELECT this,that,theother,ding,dong FROM table WHERE blah='$blah' AND
this='$that' ORDER BY something LIMIT 1000";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
// all of the row extracts
//
}
mysql_free_result($result);
// subsequent programming
blah blah...