dallas Fri Aug 12 11:28:32 2005 EDT
Modified files: /phpdoc/en/faq databases.xml Log: Wrap long lines. http://cvs.php.net/diff.php/phpdoc/en/faq/databases.xml?r1=1.28&r2=1.29&ty=u Index: phpdoc/en/faq/databases.xml diff -u phpdoc/en/faq/databases.xml:1.28 phpdoc/en/faq/databases.xml:1.29 --- phpdoc/en/faq/databases.xml:1.28 Fri Aug 12 09:33:13 2005 +++ phpdoc/en/faq/databases.xml Fri Aug 12 11:28:31 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.28 $ --> +<!-- $Revision: 1.29 $ --> <chapter id="faq.databases"> <title>Database issues</title> <titleabbrev>Database issues</titleabbrev> @@ -25,7 +25,7 @@ <para> On Unix machines, you can use the Sybase-CT driver to access Microsoft SQL Servers because they are (at - least mostly) protocol-compatible. Sybase has made a + least mostly) protocol-compatible. Sybase has made a <ulink url="&url.sybase.ctlib;">free version of the necessary libraries for Linux systems</ulink>. For other Unix operating systems, you need to contact Sybase for the correct libraries. @@ -119,7 +119,7 @@ Select the table to link, press OK, and presto! You can now open the table and add/delete/edit data on your MySQL server! You can also build queries, import/export tables to MySQL, - build forms and reports, etc. + build forms and reports, etc. </simpara> </listitem> </itemizedlist> @@ -168,26 +168,26 @@ <para> Most likely what has happened is, PHP 4 was compiled with the <option role="configure">--with-mysql</option> option, without specifying the - path to MySQL. This means PHP is using its built-in MySQL client - library. If your system is running applications, such as PHP 3 as a + path to MySQL. This means PHP is using its built-in MySQL client + library. If your system is running applications, such as PHP 3 as a concurrent Apache module, or auth-mysql, that use other versions of MySQL clients, then there is a conflict between the two differing versions of those clients. </para> <para> Recompiling PHP 4, and adding the path to MySQL to the flag, - '<link linkend="mysql.configure">--with-mysql=/your/path/to/mysql</link>' + '<link linkend="mysql.configure">--with-mysql=/your/path/to/mysql</link>' usually solves the problem. </para> </answer> </qandaentry> - + <qandaentry id="faq.databases.mysql.php5"> <question> <para> PHP 5 no longer bundles MySQL client libraries, what does this mean to me? Can I still use MySQL with PHP? I try to use MySQL and get - "function undefined" errors, what gives? + "function undefined" errors, what gives? </para> </question> <answer> @@ -233,13 +233,15 @@ ones who know what they are doing, tend to always build PHP against their system's libmyqlclient library simply by adding the <option role="configure">--with-mysql=/usr</option> option - when building PHP. Windows users may enable the extension - <filename>php_mysql.dll</filename> inside &php.ini;. For more details, see the <link linkend="ref.mysql">MySQL Reference</link> for installation instructions. Also, be sure + when building PHP. Windows users may enable the extension + <filename>php_mysql.dll</filename> inside &php.ini;. + For more details, see the <link linkend="ref.mysql">MySQL Reference</link> + for installation instructions. Also, be sure <filename>libmysql.dll</filename> is available to the systems PATH. - For more details on how, read the FAQ on - <link linkend="faq.installation.addtopath">setting up the Windows + For more details on how, read the FAQ on + <link linkend="faq.installation.addtopath">setting up the Windows systems PATH</link>. Because <filename>libmysql.dll</filename> (and - many other PHP related files) exist in the PHP folder, you'll want to + many other PHP related files) exist in the PHP folder, you'll want to add the PHP folder to your systems PATH. </para> </answer> @@ -266,9 +268,9 @@ <qandaentry id="faq.databases.mysqlresource"> <question> <para> - Why do I get an error that looks something like this: - "Warning: 0 is not a MySQL result index in <file> - on line <x>" or "Warning: Supplied argument is not + Why do I get an error that looks something like this: + "Warning: 0 is not a MySQL result index in <file> + on line <x>" or "Warning: Supplied argument is not a valid MySQL result resource in <file> on line <x>? </para> </question> @@ -276,7 +278,7 @@ <para> You are trying to use a result identifier that is 0. The 0 indicates that your query failed for some reason. You need to check for errors - after submitting a query and before you attempt to use the returned + after submitting a query and before you attempt to use the returned result identifier. The proper way to do this is with code similar to the following: <programlisting role="php">