Topic: problem regarding PHP 5.2.0+ Apache 2.2.4 +MySql4.1.19

[jawaidpk]

well I have just installed my PHP 5.2.0 but when I tried to execute

$dbh = mysql_connect("localhost","root","root") or die("could not open the database");
mysql_select_db("database",$dbh);
$res = mysql_query("SELECT * FROM table");
echo mysql_num_rows($res);

I saw nothing infact a blank page. so what might be the problem??

Remeber I have executed mysqlinfo.php & the output shows the successful connection to mysql something like this.....

User root connected to the MySQL server at localhost

Mysql version: 4.1.19-community-nt

[James Blond]

Enabled short tags in php.ini?

[useless81]

mysql_select_db("database");

is all you need there, you can not pass the handle. (I dont anyway),

Try changing your query to SELECT * FROM table WHERE 1

Without the WHERE clause you are returning zero rows I believe.