No connection with MySQL

steef

Just installed MySQL on mu Linux RedHat 6.0 machine with RPM and made a siple database.
Apache, PHP3, and MySQL were pretty basis installation.
Copied a PHP3 script into an html-page:

<?
msql_connect ("localhost");
$result = msql_list_tables ("guestbook");
$i = 0;
while ($i < msql_numrows ($result)) {
$tb_names[$i] = msql_tablename ($result, $i);
echo $tb_names[$i] . "<BR>";
$i++;
}
?>

executing this page result in the following error:
Fatal error: Call to unsupported or undefined function msql_connect() in /home/httpd/html/toontabellen.php3 on line 10

what's going on?

jodeleeuw

ready to say "DOH" and slap yourself on the head?

its mysql_conect

not msql_connect

🙂

Anon

it's mysql_connect()..

not mysql_conect..

if you are going to reply to someone, spell it right...

steef

Don't want to be a wise-ass but the php-manual states: msql_connect

jodeleeuw

Right. That's for an mSQL database. It can all be very confusing... and you did state you installed a MySQL database. I think if you change all your mSQL functions to mysql functions you will have better results.

jodeleeuw

whoops!

steef

how do I change the functions from msql_xxx to mysql_xxx within PHP?

P.S. Are you by any change Dutch?

jodeleeuw

If you want a script that will change everytrhing, I have no idea what to do.. the easiest way I know of is to go in and add the 'y' to all your "msql" functions.

I have a dutch background but I was born in the good ol USA 🙂

steef

I finally figured out what the problem was..My PHP3 module wasn't supporting MySQL. After reistalling PHP3 --with-mysql it all worked!!

Sorry to have botherd you with my ignorence (I'm still new to this game)

Thanks for your help!