num_row error

[phingoc]

Warning: mysql_num_rows() expects parameter 1 to be resource

 

what am i doing wrong?

 

i have checked, double checked and tripple checked everything.

 

include("mysql_connect.php");
$query = "SELECT * FROM prod2011 WHERE dato BETWEEN '$nyfra' AND '$nytil'";
$antall = mysql_num_rows($query); // I get error on this line.
echo "Antall linjer i listen: " . $antall;

[Pikachu2000]

The query is never actually executed with mysql_query().

 

$query = "SELECT * FROM prod2011 WHERE dato BETWEEN '$nyfra' AND '$nytil'";
$result = mysql_query($query);
$antall = mysql_num_rows($result);