Help with if/else statement

pdn

Hello,

I have a php that calls results from mysql db. Currently if no results are available it just displays a blank page. I would like to have it echo something like No results available. I know it is probably a very easy fix but I am very new to PHP. Enclosed below is my current code

<?php
$username="root";
$password="pass";
$hostname="localhost";

// Connect to Database
$dbh=mysql_connect($hostname, $username, $password)
or die("Unable to connect to Database");
$selected=mysql_select_db("offenderdb",$dbh)
or die("Unable to select offenderdb");

$result = mysql_query("SELECT ID, Name, AKA, DOB, Address, Conviction, Description, Victim, Comments, concat('<img width=320 height=240 src=\"./images/',sexoffenders.Pic, '\" border=\"0\">') AS Picture FROM sexoffenders");

while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{

?>
 
<table border="1" cellspacing="5" width="720">
<tr><th align="left" width="100">Name/AKA:</th>
<td>
<?php print $row{'AKA'}. print $row{'Name'}." "; ?>
</td><td rowspan="7" width="340"><?php print $row{'Picture'}." "; ?></td></tr>
<tr><th align="left" width="100">Address:</th>
<td><?php print $row{'Address'}." "; ?>
</tr>
<tr><th align="left" width="50">D.O.B.:</th>
<td><?php print $row{'DOB'}." "; ?>
</tr>
<tr><th align="left" width="100">Description:</th>
<td><?php print $row{'Description'}." "; ?>
</tr>
<tr><th align="left" width="100">Conviction:</th>
<td>
<?php print $row{'Conviction'}." "; ?>
</td></tr>
<tr><th align="left" width="100">Victim:</th>
<td><?php print $row{'Victim'}." "; ?>
</tr>
</table>

<?php
}

mysql_close($dbh);

thorpe

before you go into your while, check if any rows have been returned.

if (mysql_num_rows($result) <= 0) {
  echo 'no results found';
} else {
  // your while goes here
}

ps: you might also want to pull the starting <table> and ending </table> out of your while. this way all your results end up in the same table.
eg;

if (mysql_num_rows($result) <= 0) {
  echo 'no results found';
} else {
  echo '<table>';
  while ($row = mysql_fetch_array($result)) {
    // rest of code in here.
  }
  echo '</table>';
}

pdn

Thank you.... That worked great!