如果DB表中有0项，则返回错误

Question

I am looking for a way to display an error message if there is nothing listed in the table.

I have a photos table.

If this tables is empty, id like to echo something.

else, show the pictures.

inside of that table I have

id, name, url
id = id
name = name of image
url = url of image.

If there are no rows, we have an error.

$query1 = mysql_query("SELECT COUNT(*) FROM photos;");
mysql_fetch_array($query1);
if(empty($query1)) {
echo "nothing";
} else {
echo "good";
}

Answer 1

What about something like...

$sql = "SELECT COUNT(*) AS amountPhotos FROM photos";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if ($row["amountPhotos"] == 0) {
  echo "There are no photos in the photo table.";
}

or

$sql = "SELECT * FROM photos LIMIT 1";
$result = mysql_query($sql);
if (mysql_num_rows($result) == 0) {
  echo "There are no photos in the photo table.";
}