PHP 5.0 and MYSQL

Sorry Michael,

How about communicate between them!

This is the code I am using:-

<?php
$dbcnx = mysql_connect("localhost", "user", "password");
mysql_select_db("maintable");
$result = mysql_query("SELECT * FROM test");
while ($data = mysql_fetch_array($result)) {
do something
}
?>

This works fine on my FC3 machine but not on the FC4 machine.

Cheers

Peter


"Michael Phipps" wrote in message

>> Hi Guys,
>>
>> I have just upgrade my FC3 to FC4 and included was php 5.0. This
>> apparently doesn't have the mysql client files that php 4.0 used to. I
>> have enabled the mysql.so module in the mysql.ini file in /etc/php.d but
>> still cannot get mysql to talk to php. Is there anything else I can try
>> other than configure php from tarballs rather than rpm's?
>>
>
> Don't you mean get PHP to talk to MySQL?
>
> What PHP code are you using to test the MySQL connection?
>
>
>
 >> Stay informed about: PHP 5.0 and MYSQL 

"Peter W Johnson" wrote in


> Sorry Michael,
>
> How about communicate between them!
>
> This is the code I am using:-
>
> <?php
> $dbcnx = mysql_connect("localhost", "user", "password");
> mysql_select_db("maintable");
> $result = mysql_query("SELECT * FROM test");
> while ($data = mysql_fetch_array($result)) {
> do something
> }
> ?>
>
> This works fine on my FC3 machine but not on the FC4 machine.

it sure must be hard to debug anything if you don't have any error
messages!

line 2 should be
@ $dbcnx = mysql_connect("localhost", "user", "password") or die ("There
is an error - ".mysql_error()."!");

ask what the error is! it will make fixing it a whole lot easier.

an early guess is that your current mysql setup is using the old mysql
password format while your new setup is expecting a new-style mysql
password.
 >> Stay informed about: PHP 5.0 and MYSQL