Warning: mysql_num_rows() error

[Lauj]

We were using PHP 4.0.6 and we upgraded to PHP 5.0.3. I am getting the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in F:\wwwroot\home\myName\evtSearchPage.php on line 171

Line 171 is this line:

$num_results = mysql_num_rows($result);

The code below is my query.

$query = "select * from event where Month like '%".$slMonth."%' And Year like '%".$year."%' ORDER BY Day";
		$result = mysql_query($query);
		$num_results = mysql_num_rows($result);

ljCharlie

[bastien]

Your query may have a problem. Try this to get some meaningful error messages

$result = mysql_query($query) or die(mysql_error());

[TheDefender]

Was it working before you upgraded your PHP version to 5.0.3?