cvs: phpdoc /en/functions mysql.xml

jeroen Wed May 16 15:46:44 2001 EDT Modified files: /phpdoc/en/functions mysql.xml Log: Reapplied 1.37 -> 1.40 patches Index: phpdoc/en/functions/mysql.xml diff -u phpdoc/en/functions/mysql.xml:1.41 phpdoc/en/functions/mysql.xml:1.42 --- phpdoc/en/functions/mysql.xml:1.41 Wed May 16 08:25:31 2001 +++ phpdoc/en/functions/mysql.xml Wed May 16 15:46:43 2001 @@ -479,7 +479,8 @@ arguments </para> <para> - See also <function>mysql_connect</function>. + See also <function>mysql_connect</function> and + <function>mysql_query</function>. </para> <para> For downwards @@ -1764,10 +1765,55 @@ <para> See also: <function>mysql_affected_rows</function>, <function>mysql_db_query</function>, + <function>mysql_unbuffered_query</function>, <function>mysql_free_result</function>, <function>mysql_result</function>, <function>mysql_select_db</function>, and <function>mysql_connect</function>. + </para> + </refsect1> + </refentry> + + <refentry id="function.mysql-unbuffered-query"> + <refnamediv> + <refname>mysql_unbuffered_query</refname> + <refpurpose>Send an SQL query to MySQL, without fetching and buffering the result rows</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcprototype> + <funcdef>int <function>mysql_unbuffered_query</function></funcdef> + <paramdef>string <parameter>query</parameter></paramdef> + <paramdef>int + <parameter><optional>link_identifier</optional></parameter> + </paramdef> + <paramdef>int + <parameter><optional>result_mode</optional></parameter> + </paramdef> + </funcprototype> + </funcsynopsis> + <para> + <function>mysql_unbuffered_query</function> sends a SQL query to MySQL, + without fetching and buffering the result rows automatically, as + <function>mysql_query</function> does. + On the one hand, this saves a considerable amount of memory with SQL + queries that produce large result sets. On the other hand, you can start + working on the result set immediately after the first row has been + retrieved: you don't have to wait until the complete SQL query has been + performed. + </para> + <note> + <para> + The benefits of <function>mysql_unbuffered_query</function> come at a + cost: You cannot use <function>mysql_num_rows</function> on a result set + returned from <function>mysql_unbuffered_query</function>. You also have + to fetch all result rows from an unbuffered SQL query, before you can + send a new SQL query to MySQL. + </para> + </note> + <para> + See also: <function>mysql_query</function>. </para> </refsect1> </refentry>