Re: mysql not supporting php.
David Grant wrote: This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. This means your PHP was not compiled with MySQL support. Recompile PHP. Also, does anyone know the command to list all the db's? thanks. show databases; -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql not supporting php.
The follow lines will -list DBs -allow to select one -list tables under the selected DB mysql show databases; mysql use databasenamehere mysql show tables; hope this helped! -Original Message- From: David Grant [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 12:21 PM To: My SQL Mailing List Subject: mysql not supporting php. mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not supporting php.
On Monday 03 Jun 2002 9:50 am, David Grant wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. PHP isn't compiled with MySQL support. Recompile php and add --with-mysql to the configure script. Also, does anyone know the command to list all the db's? thanks. SHOW DATABASES; Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not supporting php.
It sounds as if you didn't compile in mysql support with you php executable. You can check this using the phpinfo() function. If you are using the cgi only, try something like... 'php -q -i | grep configure' This will show you all the configuration options you selected when compiling/installing php. There will be some html junk you'll have to sift through, but you should be able to see it. As for showing the db's, try mysqlshow. If you want to see the tables in a db, mysqlshow db_name. If you want to see the info for one table in a db, mysqlshow db_name table_name. Later on, Big Din KR (Terrence :-|) - Original Message - From: David Grant [EMAIL PROTECTED] Date: 02 Jun 2002 23:50:53 -0700 To: My SQL Mailing List [EMAIL PROTECTED] Subject: mysql not supporting php. mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not supporting php.
At 01:50 AM 6/3/2002, you wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave Dave, Switch to PHP 4.2.1 which has MySQL built into it. It also fixes some security problems. See www.php.net for download. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php