mysql_num_rows() error

[Hatch]

I get this error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource 

From this code

$month_txt = date("F Y", mktime(0,0,0,date("m")+$i,date("d"),date("Y")));
$from_date = date("Y-m-d H:i:s", mktime(0,0,0,date("m")+$i,01,date("Y")));
$to_date = date("Y-m-d H:i:s", mktime(23,59,59,date("m")+$i+1,00,date("Y")));
$query = "SELECT * FROM calendar WHERE fromDate >= '".$from_date."' AND fromDate <= '".$to_date."' ORDER BY fromDate'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

My table has these fields...ID,fromDate,toDate,title,description

For some reason my query statement isn't working. All the dates are stored as YYYY-MM-DD 00:00:00.

Any ideas?

[Stoned_Gecko]

It's possible that the query is failing, and that's why the result is invalid. Try this query line:

$result = mysql_query($query) or die("<pre>" . mysql_error() . "\n\nLast query: $query</pre>");

That should show you the query that's running and the error that mysql is returning.

[Hatch]

Thanks for the tip. Just one little apostophe at then end of the query screwed it up. All works fine now 🙂 Appreciate the help.