PHP+MySQL+Linux

jkh168

After migrating my website from W2K to Linux, the MySQL calls from PHP stopped working.

I found that:
(1) $link = mysql_connect($server, $user, $pass) did return a valid identifier.

(2) $result = mysql_query($sql, $link) did not return anything at all, not even true or false.

Please help.

Anon

Make sure that your changed your server variable value to the correct address. Also make sure that PHP was properly compiled for MySQL support. In other words using MySQL libraries, instead of the libraries that come with PHP.

Try doing some simple troubleshooting tasks.

if(!$link = mysql_connect($server, $user, $pass)){
print mysql_error();
}

jkh168

Thanks for your suggestions.

I do have the correct server name (tried both 127.0.0.1 and host name). As to the MySQL libraries, I used the PHP-MySQL libraries that came with Mandrake 8.1.

At the shell, I could query the database, so I know the server is running. In fact, the mysql_connect() did give me a valid identifier (print $link gave me a positive integer). But the mysql_query() didn't return anything at all!

Here are my platform info:
(1) Mandrake Linux 8.1
(2) PHP 4.0.6
(3) MySQL 3.23.41
(4) Apache 1.3.20

Could you give me more ideals as to where to start looking? Thanks.

Anon

Print out your query to a browser, and then copy and paste into commandline client. Make sure you are returning records sets.

            then try

if(!$sth = mysql_query($query,$link)){
print "Error: " . mysql_error();
}

meni0n

Hey,
Did you do mysql_select_db($database) after connecting ?

jkh168

Sorry that I didn't include it in my sample code. But, yes, I did do that before calling the query function.