Hi,

I am trying to access a mysql database using php from the client. other php pages without mysql embeded within are working fine.

my php code is


<?php
$link = mysql_connect("192.168.168.141", "sm", "ninanina")
or die ("could not connect :" . mysql_error());
print " Connected Successfully \n\n";
mysql_select_db ("test") or die ("could not select database");

$query = "Select * from persons";
$result = mysql_query($query)
or die ("query failed : " . mysql_error());

print "<tables> \n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t <tr> \n";
foreach ($line as $col_value) {
print "\t\t<td> $col_value <\td> \n";
}
print "\t <\tr> \n";
}
print "<\t <\tr> \n";
mysql_free_Results($result);
mysql_close($link);
?>



the error i am getting from the remote machine is "page cannot be displayed"

hoping for an early response.

thanks in advance,

Please put your code between [ code] or [ php] tags. That makes it easier to read for us.

If that is the error message you get, it has not anything to do with MySQL. The page is not displayed at all, not even an error message from your page itself.

Most likely the permissions are not set correctly (most be world readable), or the file is not there.

jlinkels