PHP & Mysql

[Anon]

help! I'm using RedHat 7.0 with php 4.04pl and Mysql 3.23.36. My problem is that when I test a php script to access mysql database, an error appears like this :

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/login.php on line 6.

basically line 6 contains the line mysql_connect("database","user","password");

I'm a newbie with linux, php and mysql so i'd appreciate all the help i can get!!

thanx,
terx

[Anon]

me thinks you need to recompile PHP with the option '--with-mysql=/path/to/mysql' so PHP may recognize the PHP functions you're trying to call

ALEMAN

[Anon]

$connect = mysql_connect('localhost', 'root', 'password') or die ("Couldnt connect");
mysql_select_db('database', $connect) or die ("Couldnt open Database");
$sql = "SELECT * FROM table_name";
$result = mysql_query($sql) or die ("Couldnt get results");

your connection string is wrong

[Anon]

but running the script on Windows seems to be working well.. and may i know how to recompile PHP. When I installed Linux, PHP was installed together with it!!

[Anon]

This maybe a stupid question but is the my_connect function in the same file or is it in a different file(you would need to do an include statement). If not I would first check spelling and syntax, in other words you may need to do a little bit of sluthing.

Let me know if this helps,
Tracy

[Anon]

thnaks Tracy for da hints, but da problem is not with the script, I guess as I did da coding under Windows and it works perfectly fine. only when i transfer da files to Linux (making sure da database, table, user and password are correct)that the php gives da error msg. checkin on da php version, i discovered dat php was compiled without mysql. so how do i go about it??

cheers ,terx

[joshsisk]

you need to recompile php with mysql support. it explains how to do it on www.php.net, in the "installation" section.