When Mysql has no data to show how to display a message saying "no data was found"

[iBuddy]

I have a database setup where it grabs stuff from a mysql db. Everything is running fine, however sometimes the table has no content in their and I want it to display "currently there are no items in this table" how do I do that?

[kevinsequeira]

<? 
// connect to database first
mysql_connect("host","username","password");
//select database
mysql_select_db("database");
// generate the query
$query = "SELECT * FROM tablename";
// execute the query
$result = mysql_query($query);
//check for error
if(mysql_error()){
 echo mysql_error();
  exit;
}else{
// check for number of rows
if(mysql_num_rows($result) <1){
 echo "no results";
}else{
// display results
}
}
//close the connection to the db
mysql_close();
?> 

[stolzyboy]

simple

<?
$query = "select * from table;";
$result = mysql_query($query) or die(mysql_error());

if (mysql_num_rows($result) == 0)
{
echo "there are no results";
}
else
{
while ($row = mysql_fetch_array($result))
{
echo "your results here";
}
}
?>

something like that should do

[iBuddy]

thanks to both of u for providing help...you guys are so fast on this site and so knowledgable i love it!