mysql_connect error

[CanWeb]

I am experiencing a problem with a script to connect o my database. I get this msg:

Fatal error: Call to undefined function mysql_connect() in c:\...\connect.test.php

and this is the offending line:

$conn = @mysql_connect($mysql_host, $mysql_user, $mysql_password) or die("Sorry, couldn't connect to the datebase!<br>Please try later again!");

Why would I get an error like this when has been working fine for a few years now?
Irvin.

[jadah]

what version of php are u using?

if u just upgraded to php 5 then u have not configured it to run with MySql.

[CanWeb]

Assuming my host upgraded php to 5.0, what would be the correct way to connect? This is what I currently use:

$conn = @mysql_connect($mysql_host, $mysql_user, $mysql_password) or die("Sorry, couldn't connect to the datebase!<br>Please try later again!");
$db = @mysql_select_db ($mysql_db) or die("Sorry, could not find the database");

The vars are declared in an other file which are included on the page.
Or do you mean that it's not my script but that the mySQL server needs to be re-installed to work?

[devbanana]

Looks like PHp5 was not configured to work with MySQL. You'll wan tto contact your host about this.

In any case, as of PHP 5.1, you should look into using PDO anyway.

[wmbetts]

yeah it looks like someone forgot --with-mysql when they typed ./config

[CanWeb]

Looks like he's uped php to 5.0.x. Phpinfo does not indicate a mySQL server but rather shows something like SQLite. I think I need to change hosts! We got on notice at all about the changes. Sigh.

Thanks for the help guys.
Irvin. <><