Can't connect PHP to MySQL in Kubuntu

[peterv6]

I'm trying to run php scripts on Kubuntu 10.04 that connect to a MySQL database. These scripts run perfectly on OS X 10.6.6, but when I run them in Kubuntu, I get the following error:

The script...
<?php
$mysql = mysql_connect('127.0.0.1', 'peterv', 'password');
if (mysql_connect_errno()) {
printf("Connect failed: %s\n", mysql_connect_errno());
exit();
} else {
printf("Host information: %s\n", mysql_get_host_information($mysql));
}
?>

The error message:
"Fatal error: Call to undefined function mysql_connect() in..."

I've seen some posts in other boards about Red Hat problems like this, but nothing that can help with Kubuntu. I'd really appreciate a hand with this.
Thanks,
Peter V.

[wiggly81]

i have made a few edits and it works on my system

<?php
	$mysql = MySQL_Connect('localhost', 'root', 'password');
		if(!$mysql) {
			printf("Connect failed: %s\n", mysql_error());
			exit();
		} else {
			printf("Host information: %s\n", mysql_get_host_info($mysql));
		}
?>

hope it helps some

[peterv6]

wiggly, thanks for the attempt, but it still doesn't work. Since it's giving me an error for an undefined function call, I think it has something to do with my php installation.

[wiggly81]

can you post the whole error?

[peterv6]

Sure:

Fatal error: Call to undefined function mysql_connect() in /var/www/LP2/dbc.php on line 2.

Thanks for looking!

[norima]

you installed php and mysql separately. you should install php-mysql