php-mysql problem
| From: | Jianping Zhu | Date: | Thu, 13 May 2004 15:47:41 +0000 |
| Subject: | php-mysql problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34420@lists.php.net to get a copy of this message | ||
have redhat 9.0 and Server version: Apache/2.0.40.
i have installed rpms php-4.2.2-17.2.i386.rpm
php-mysql-4.2.2-17.2.i386.rpm
After i create a database called mydb and serveral tables in mysql,
I tried to run following testdb.php script
------------------------------------------------------------------
<html>
<body>
<?php
$db = mysql_connect("localhost", "root","xxxxxx");
mysql_select_db("mydb",$db);
$result = mysql_query("SELECT * FROM employees",$db);
printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
printf("Address: %s<br>\n", mysql_result($result,0,"address"));
printf("Position: %s<br>\n", mysql_result($result,0,"position"));
?>
</body>
</html>
---------------------------------------------------------------
but i got error message with:
http://coopunit.forestry.uga.edu:8080/testdb.php
the error is:
Fatal error: Call to undefined function:
mysql_connect() in /var/www/html/testdb.php on line 13
How can Fix this problem? Thanks