mysql_num_rows error

[narjis]

why does my mysql_num_rows always give the same err

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp2\www\e_commerce\e_commerce\admin\viewProducts.php on line 8

 

$conn= mysql_connect("localhost","root","");
mysql_select_db("ecommerce",$conn);
$product_list="";
$sql = "SELECT * FORM products";
$query = mysql_query($sql,$conn);
$exist = mysql_num_rows($query);

although the very same code is running fine in another file of the same project.

Please help me.

[Pikachu2000]

Because the query is failing. Read the query string carefully, looking for misspellings.

[fugix]

If you pasted that code from your editor, you have mispelled FROM here

$sql = "SELECT * FORM products";

 

[colap]

why does my mysql_num_rows always give the same err

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp2\www\e_commerce\e_commerce\admin\viewProducts.php on line 8

 

$conn= mysql_connect("localhost","root","");
mysql_select_db("ecommerce",$conn);
$product_list="";
$sql = "SELECT * FORM products";
$query = mysql_query($sql,$conn);
$exist = mysql_num_rows($query);

although the very same code is running fine in another file of the same project.

Please help me.

 

So what was the error ?

[Nuv]

$sql = "SELECT * FORM products";

 

Its FROM not FORM. although OP already realised his mistake, this was for php-coder.

[fugix]

$sql = "SELECT * FORM products";

 

Its FROM not FORM. although OP already realised his mistake, this was for php-coder.

I've already stated this