georg Wed Feb 13 17:13:27 2002 EDT
Modified files:
/phpdoc/en/functions mysql.xml
Log:
a) inserted mysql_free_result in example
b) changed mysql_query description: mysql_query returns a resultset for SELECT,
EXPLAIN
DESCRIBE and SHOW statements, not only for select statements.
Index: phpdoc/en/functions/mysql.xml
diff -u phpdoc/en/functions/mysql.xml:1.85 phpdoc/en/functions/mysql.xml:1.86
--- phpdoc/en/functions/mysql.xml:1.85 Sat Feb 2 10:36:04 2002
+++ phpdoc/en/functions/mysql.xml Wed Feb 13 17:13:26 2002
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.85 $ -->
+<!-- $Revision: 1.86 $ -->
<reference id="ref.mysql">
<title>MySQL Functions</title>
<titleabbrev>MySQL</titleabbrev>
@@ -111,6 +111,9 @@
}
print "</table>\n";
+// Free resultset
+mysql_free_result($result);
+
// Closing connection
mysql_close($link);
?>
@@ -1793,7 +1796,8 @@
</para>
</note>
<para>
- Only for SELECT statements <function>mysql_query</function>
+ Only for SELECT,SHOW,EXPLAIN or DESCRIBE statements
+ <function>mysql_query</function>
returns a resource identifier or &false; if the query was
not executed correctly. For other type of SQL statements,
<function>mysql_query</function> returns &true; on success
@@ -1849,7 +1853,8 @@
statement.
</para>
<para>
- Only for SELECT statements, <function>mysql_query</function>
+ Only for SELECT,SHOW,DESCRIBE or EXPLAIN statements,
+ <function>mysql_query</function>
returns a new result identifier that you can pass to
<function>mysql_fetch_array</function> and other
functions dealing with result tables. When you are done with the
