doh. sorry for the previous message i pasted an old one. anyway, here's my problem:
Fatal error: Call to undefined function: mysql_connect() in /var/www/test2.php on line 15 this appears whenever i tried to open "http://localhost/test2.php";. i installed LAMP using apt-get like so: apt-get install apache-perl mysql-server mysql-client php4 php4 is working fine with apache as i've tested opening a test.php file with "<? phpinfo(); ?>" as the only contents. it showed what is expected. mysql on the other hand is only tested directly within mysql when i created the sample database "books". what am i missing or do i really have to use the source to make it work? i prefer using all .deb package as that's how i update my kernel using kernel-package. test2.php contents is here: <html> <head> <title>Example 2 -- more details</title> </head> <body bgcolor="white"> <? $dbuser='root'; $dbhost='localhost'; $dbpass='password'; $dbname='test2'; $dbtable='books'; //---------- DATABASE CONNECTION ------------// $mysql_link = mysql_connect($dbhost,$dbuser,$dbpass); $column = mysql_list_fields($dbname,$dbtable,$mysql_link); $sql = "select * from $dbtable"; $result = mysql_db_query($dbname,$sql); ?> <table bgcolor="black"> <tr><td> <table><!---- Inside Table ----> <? while($value = mysql_fetch_array($result)) { print "<tr BGCOLOR=YELLOW>"; //This loop goes through the columns and prints //each value for ($i=0; $i < mysql_num_fields($column); $i++) { print "<td> $value[$i] </td>"; } print "</tr>"; } mysql_free_result($result); mysql_close(); ?> </table><!---- Inside Table ----> </td></tr> </table> </body> </html> -- -------------------------------------------------------------------- Key fingerprint = 9DE1 5825 77B4 FF45 7485 D3EB DCCF DE48 09B6 4426 -------------------------------------------------------------------- "Who's watching the watchmen?"
pgp22AuvnWDqT.pgp
Description: PGP signature
