Mysql Is Not Returning Any Row

[tahakirmani]

I am writing the following code in my PHP program, but mysql is not returning any row. Kindly check and help to find out the mistakes in the following code.

 

<?php


 $query= "SELECT * FROM `email` where `id` =' ".$_SESSION['user_id']. "'" ;
	 $query_run2= mysql_query($query);
	 $query_num_rows= mysql_num_rows($query_run2);
		 if ($query_num_rows==0) {
			 echo "Invalid Query";
		 }
			 else {
				 $query_result = mysql_result ($query_run2, 0, 'name');
				 echo "Welcome" ;
				 echo $_SESSION['user_id'];
}
?>

 

It is giving me the following Output.

 

Log out Warning: mysql_num_rows() expects parameter 1 to be resource, string given in F:\xampp\htdocs\Email_address\welcome.php on line 20 Invalid Query

 

 

Thanks,

Taha.

[Barand]

Check output from mysql_error()

[PFMaBiSmAd]

The code you posted cannot possibly produce the error you are getting, ... string given ... unless your actual code is something like - $query_num_rows= mysql_num_rows($query);

[tahakirmani]

Thank you so much for the help..I did a stupid mistake, when i use mysql_error() function,then i come to know that i was not connected to Database.