If an MySQL Row is Empty How do I echo that it is??

[stublackett]

Hi,

 

I've got a MySQL Select Script setup

 

It selects the data no problems, What I'd like to do is if the SQL Data that is empty or doesnt match the SQL Command, How do I say "No News In The Archive" ??

 

My code is

<?php 
$result = mysql_query("SELECT * , DATE_FORMAT( date, '%c' ) AS month FROM news WHERE date >= 1 & date <=3"); //&c is the month number (i.e 1 for January, 2 for Feb etc)
while($myrow = mysql_fetch_assoc($result)) 
              
        {//begin of loop
$date = $myrow['month'];
$title = $myrow['title'];
$description = $myrow['description'];

if ( $date >= 1 && $date <= 3)
{ 
//Winter News Archive
echo "<h2>$title</h2>";
echo "<div id='description'>$description</div>";
echo "<br>";
}

	}//End While loop
         						
?>

 

 

[waynew]

Here you go:

 

if(mysql_num_rows($result) == 0) //its empty

 

Hope that helped. 

[stublackett]

Haha, Should have worked that out myself

 

Especially with the == already being in my code

 

Thanks for that though

[waynew]

No problem.