Configuring MySQL in PHP
Posted: Thu Apr 18, 2002 5:17 pm
I have downloaded and installed PHP successfully on my PC running Windows NT using the Windows installer version rather than compiling source. The basic PHP commands seem to be working. However MySQL does not seem to be working from within PHP...
The symptoms are that the mysql_connect( ) and mysql_select_db( ) are completing OK but actual SQL done via mysql_query( ) is returning false result (no error though).
I downloaded MySQL separately and can run mysqladmin and the DOS interface where I can create tables and query them.
I notice in the PHP documentation that from PHP4 has MySQL "built into PHP". There are also comments about having to tell PHP where the MySQL implementation is if you do not want to use the built in version. But how do you do this? I can't work out where to put the directive to tell PHP to use MySQL in the c:/mysql directory or even if I need to do this...
Help! Anyone got any ideas/answers?
The symptoms are that the mysql_connect( ) and mysql_select_db( ) are completing OK but actual SQL done via mysql_query( ) is returning false result (no error though).
I downloaded MySQL separately and can run mysqladmin and the DOS interface where I can create tables and query them.
I notice in the PHP documentation that from PHP4 has MySQL "built into PHP". There are also comments about having to tell PHP where the MySQL implementation is if you do not want to use the built in version. But how do you do this? I can't work out where to put the directive to tell PHP to use MySQL in the c:/mysql directory or even if I need to do this...
Help! Anyone got any ideas/answers?