if myqsl table empty how to display a message

mysql, table, empty, display, sorry no entries

[beebob1]

Hi, on my php page i want to display a message if the table is empty, heres my code, im not sure how or where i would put such a message..ta. I suppose some sort of conditional statment, if/else "sorry no entries". Im new to php so any help would be appreciated.

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("pet") or die(mysql_error());

$result = mysql_query("SELECT * FROM example")
or die(mysql_error());

while($row = mysql_fetch_array( $result ))

{

$age=$row["age"];
$name=$row["name"];
$date=$row["date"];
$id=$row["id"];

echo "<p>ID: $id</p> <p>Date: $date</p> <p>Age: $age</p>";
echo "Name: ".nl2br($row['name']);

}

mysql_close();
?>

[elitebomber]

You can use mysql_num_rows($result) to count the number of rows returned.

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("pet") or die(mysql_error());

$result = mysql_query("SELECT * FROM example")
or die(mysql_error());

$numrows = mysql_num_rows($result);

if($numrows == 0){
echo "No entries";
}
else{

while($row = mysql_fetch_array( $result ))

{

$age=$row["age"];
$name=$row["name"];
$date=$row["date"];
$id=$row["id"];

echo "<p>ID: $id</p> <p>Date: $date</p> <p>Age: $age</p>";
echo "Name: ".nl2br($row['name']);

}

}

mysql_close();
?>

[beebob1]

great, thanks! works very nicely.