cvs: phpdoc /en/reference/mysql/functions mysql-fetch-array.xml

From: Date: Sun, 21 Apr 2002 14:45:01 +0000
Subject: cvs: phpdoc /en/reference/mysql/functions mysql-fetch-array.xml
Groups: php.doc 
Request: Send a blank email to phpdoc+get-969344673@lists.php.net to get a copy of this message
georg Sun Apr 21 10:45:01 2002 EDT Modified files: /phpdoc/en/reference/mysql/functions mysql-fetch-array.xml Log: inserted additional samples Index: phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml diff -u phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.2 phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.3 --- phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml:1.2 Wed Apr 17 02:41:10 2002 +++ phpdoc/en/reference/mysql/functions/mysql-fetch-array.xml Sun Apr 21 10:45:01 2002 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <!-- splitted from ./en/functions/mysql.xml, last change in rev 1.27 --> <refentry id="function.mysql-fetch-array"> <refnamediv> @@ -33,13 +33,14 @@ make an alias for the column. For aliased columns, you cannot access the contents with the original column name (by using <literal>'field'</literal> in this example). - <informalexample> + <example> + <title>Query with duplicate field names</title> <programlisting role="sql"> <![CDATA[ -select tone.field as foo ttwo.field as bar from tone, ttwo +select table1.field as foo table2.field as bar from table1, table2 ]]> </programlisting> - </informalexample> + </example> </para> <para> An important thing to note is that using @@ -62,30 +63,62 @@ using MYSQL_NUM, you only get number indices (as <function>mysql_fetch_row</function> works). </para> - <para> - For further details, see also - <function>mysql_fetch_row</function> and - <function>mysql_fetch_assoc</function>. - </para> <example> - <title><function>mysql_fetch_array</function> example</title> + <title>mysql_fetch_array with MYSQL_NUM</title> + <programlisting role="php"> +<![CDATA[ +<?php + mysql_connect("localhost", "mysql_user", "mysql_password"); + + $result = mysql_query("SELECT id, name FROM mytable"); + + while (($row = mysql_fetch_array($result, MYSQL_NUM)) + printf ("ID: %s Name: %s", $row[0], $row[1]); + + mysql_free_result($result); +?> +]]> + </programlisting> + </example> + <example> + <title>mysql_fetch_array with MYSQL_ASSOC</title> <programlisting role="php"> <![CDATA[ <?php - mysql_connect($host, $user, $password); - mysql_select_db("database"); - $result = mysql_query("select user_id, fullname from table"); - while ($row = mysql_fetch_array($result)) { - echo "user_id: ".$row["user_id"]."<br />\n"; - echo "user_id: ".$row[0]."<br />\n"; - echo "fullname: ".$row["fullname"]."<br />\n"; - echo "fullname: ".$row[1]."<br />\n"; - } + mysql_connect("localhost", "mysql_user", "mysql_password"); + + $result = mysql_query("SELECT id, name FROM mytable"); + + while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) + printf ("ID: %s Name: %s", $row["id"], $row["name"]); + mysql_free_result($result); ?> ]]> </programlisting> </example> + <example> + <title>mysql_fetch_array with MYSQL_BOTH</title> + <programlisting role="php"> +<![CDATA[ +<?php + mysql_connect("localhost", "mysql_user", "mysql_password"); + + $result = mysql_query("SELECT id, name FROM mytable"); + + while (($row = mysql_fetch_array($result, MYSQL_BOTH)) + printf ("ID: %s Name: %s", $row[0], $row["name"]); + + mysql_free_result($result); +?> +]]> + </programlisting> + </example> + <para> + For further details, see also + <function>mysql_fetch_row</function> and + <function>mysql_fetch_assoc</function>. + </para> </refsect1> </refentry>

« previous php.doc (#969344673) next »