if($query <= 0)....

[nathanmaxsonadil]

I'm trying to get it to display something if there's nothing in the database

the current code I have now is

 

if($query <= 0) {
echo "<div id='posts'><h2>Nothing to display</h2>
<p>Sorry we don't have anything to display.<br/>Suscribe to our <a href='http://myurl.com/feednews'>rss</a> feed for updates!</p></div>";
} else {
//my code to execute if more that 0 in database
}

however that does not display anything even when there is 0 in the database

what should I use instead?

[willpower]

what is $query

 

if it is a result then it will include something

 

presumably you should be looking for the number if results returned...and i would find $query a strange var to use....can you expand.

 

Will

[nathanmaxsonadil]

$query is a mysql query

 

$query = mysql_query("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 10") or die(mysql_error());

[jcombs_31]

you can check if any rows were returned

 

if mysql_num_rows($query) == 0 { do something }