No Data

[Dysan]

I have the following code, that outputs Firstnames and Lastnames from a table inside a database.

How do I display a message if the database/table contains no Firstnames and Lastnames?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM person");

while($row = mysql_fetch_array($result))
{
  echo $row['FirstName'].'<br />';
  echo $row['LastName'].'<br />';
}

mysql_close($con);
?>

[gomisute]

put what you get from the DB into variables and check to see if they have anything in them:

<?

$firstname=$row['FirstName'];
$lastname=$row['LastName'];

//now check your variables
if($firstname!='' && $lastname!=''){

?>
<div>
First Name: <?= $firstname ?><br>
Last Name: <?= $lastname ?><br>
</div>

<? } else { ?>
<div>
Oops! No First and last names found in the DB.
</div>

<? } ?>

or something like that