mysql_num_rows():

[bravo14]

Hi Guys  I am getting the following error message from the code below

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/maypolejuniors.com/public_html/news.php on line 191

 

<?php
if(!isset ($id)){
$sql=mysql_query('SELECT * FROM tbl_news sort by story_date desc');
if(mysql_num_rows($sql)<1){ //line 191
	echo"All news about Maypole Juniors Under 7s will be available here";
}
	else{
		echo"<table>
			 <tr>
			 <td>Date</td>
			 <td>Headline</td>
			 </tr>";
		while($row = mysql_fetch_array($sql)){
		echo"<tr>
			 <td>".date("d-M-Y", strtotime($row['story_date']))."</td>
			 <td>".$row['headline']."</td>
			 </tr>";
		}
		echo"</table>";
	}
}
else
{
$story=mysql_query('SELECT * FROM tbl_news WHERE news_id="$id"');
echo("<h3>".$story['headline']."</h3>".$story['content']);
}
?>

 

What is the problem with the code?

[Philip]

It is because $sql isn't a valid MySQL resource. Or, in other words:

mysql_query('SELECT * FROM tbl_news sort by story_date desc') failed.

 

echo mysql_error() and see what it says