PHP mysql_free_result() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_free_result() function frees memory used by a result handle.
This function returns TRUE on success, or FALSE on
failure.
Syntax
| Parameter |
Description |
| data |
Required. Specifies which result handle to free. The result
handle is the return from the mysql_query() function |
Tips and Notes
Tip: PHP automatically releases the memory used by result handles at
the end of the script. However, this function can be useful when you want to
free up memory between large queries.
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));
// Free memory
mysql_free_result($result);
$sql = "SELECT * from Customers";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_row($result));
mysql_close($con);
?>
|
Complete PHP MySQL Reference
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
