cvs: phpdoc /en/functions msql.xml

jimw Thu Dec 6 21:29:01 2001 EDT Modified files: /phpdoc/en/functions msql.xml Log: msql_query: incorporate example from user note Index: phpdoc/en/functions/msql.xml diff -u phpdoc/en/functions/msql.xml:1.19 phpdoc/en/functions/msql.xml:1.20 --- phpdoc/en/functions/msql.xml:1.19 Tue Nov 20 18:58:45 2001 +++ phpdoc/en/functions/msql.xml Thu Dec 6 21:29:01 2001 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.19 $ --> +<!-- $Revision: 1.20 $ --> <reference id="ref.msql"> <title>mSQL functions</title> <titleabbrev>mSQL</titleabbrev> @@ -986,6 +986,28 @@ Returns a positive mSQL query identifier on success, or &false; on error. </para> + <example> + <title><function>msql_query</function></title> + <programlisting role="php"> +<![CDATA[ +<?php +$link = msql_connect("dbserver") + or die("unable to connect to msql server: ".msql_error()); +msql_select_db("db", $link) + or die("unable to select database 'db': ".msql_error()); + +$result = msql_query("SELECT * FROM table WHERE id=1", $link); +if (!$result) { + die("query failed: ".msql_error()); +} + +while ($row = msql_fetch_array($result)) { + echo $row["id"]; +} +?> +]]> + </programlisting> + </example> <para> See also: <function>msql</function>, <function>msql_select_db</function>, and