[PHP-DOC] cvs: phpdoc /en/functions mysql.xml From: Daniel Beckham (danbeck <email protected>)
Date: 03/08/01

danbeck Thu Mar 8 13:56:37 2001 EDT

  Modified files:
    /phpdoc/en/functions mysql.xml
  Log:
  added errata clarification and clean up some function examples
  
Index: phpdoc/en/functions/mysql.xml
diff -u phpdoc/en/functions/mysql.xml:1.36 phpdoc/en/functions/mysql.xml:1.37
--- phpdoc/en/functions/mysql.xml:1.36 Thu Feb 15 16:15:33 2001
+++ phpdoc/en/functions/mysql.xml Thu Mar 8 13:56:37 2001
@@ -46,10 +46,11 @@
      </funcprototype>
     </funcsynopsis>
     <para>
- <function>mysql_affected_rows</function> returns the number of
- rows affected by the last INSERT, UPDATE or DELETE query on the
- server associated with the specified link identifier. If the
- link identifier isn't specified, the last opened link is assumed.
+ <function>mysql_affected_rows</function> returns the number
+ of rows affected by the last INSERT, UPDATE or DELETE query
+ associated with <parameter>link_identifier</parameter>. If the
+ link identifier isn't specified, the last link opened by
+ <function>mysql_connect</function> is assumed.
     </para>
     <note>
      <para>
@@ -63,14 +64,27 @@
      of the records will have been deleted from the table but this
      function will return zero.
     </para>
+ <note>
+ <para>
+ When using UPDATE, MySQL will not update columns where the new
+ value is the same as the old value. This creates the possiblity
+ that <function>mysql_affected_rows</function> may not actually
+ equal the number of rows matched, only the number of rows that
+ were literally affected by the query.
+ </para>
+ </note>
     <para>
- This command is not effective for SELECT statements, only on
- statements which modify records. To retrieve the number of rows
- returned from a SELECT, use <function>mysql_num_rows</function>.
+ <function>mysql_affected_rows</function> does not work with
+ SELECT statements; only on statements which modify records. To
+ retrieve the number of rows returned by a SELECT, use
+ <function>mysql_num_rows</function>.
     </para>
     <para>
      If the last query failed, this function will return -1.
     </para>
+ <para>
+ See also: <function>mysql_num_rows</function>.
+ </para>
    </refsect1>
   </refentry>
 
@@ -242,11 +256,13 @@
      <title>MySQL connect example</title>
      <programlisting role="php">
 &lt;?php
- $link = mysql_connect ("kraemer", "marliesle", "secret")
+
+ $link = mysql_connect ("localhost", "username", "secret")
         or die ("Could not connect");
     print ("Connected successfully");
     mysql_close ($link);
-?>
+
+?&gt;
      </programlisting>
     </example>
     <para> See also
@@ -1533,29 +1549,30 @@
      <function>mysql_num_rows</function> returns the number of rows in
      a result set. This command is only valid for SELECT statements.
      To retrieve the number of rows returned from a INSERT, UPDATE or
- DELETE, use <function>mysql_affected_rows</function>.
+ DELETE query, use <function>mysql_affected_rows</function>.
      <example>
- <title>
- <function>
- mysql_num_rows example by crubel <email protected>
- </function>
- </title>
+ <title><function>mysql_num_rows</function> example</title>
       <programlisting role="php">
 &lt;?php
-$conn = mysql_connect("hostaddress", "username", "password");
-mysql_select_db("database",$conn); // needed if you have m,ultiple db's
-$Resultfornummembers = mysql_query("SELECT * FROM Accounts",$conn);
-$NumMembers = mysql_num_rows($Resultfornummembers);
-echo "$NumMembers Members";
-?>
+
+$link = mysql_connect("localhost", "username", "password");
+mysql_select_db("database", $link);
+
+$result = mysql_query("SELECT * FROM table1", $link);
+$num_rows = mysql_num_rows($result);
+
+echo "$num_rows Rows\n";
+
+?&gt;
       </programlisting>
      </example>
     </para>
     <para>
      See also:
- <function>mysql_db_query</function>,
- <function>mysql_query</function> and,
- <function>mysql_fetch_row</function>.
+ <function>mysql_affected_rows</function>,
+ <function>mysql_connect</function>,
+ <function>mysql_select_db</function> and
+ <function>mysql_query</function>.
     </para>
     <para>
      For downward compatibility <function>mysql_numrows</function> can