Validation

[vikheen]

Hi,

Could you please place a code in the code below so that if no record is found, a message will be displayed that no record has been found?

$result = mysql_query($sql) or die("hotelid");

while ($line = mysql_fetch_array($result))
{
foreach ($line as $xhotelid)
{}
$sqlhotelid = "select hotelname from hotel where hotelid = $xhotelid order by hotelname";
$result1 = mysql_query($sqlhotelid) or die("hotelid");
$myrow = mysql_fetch_array($result1);
$xhotelname = $myrow["hotelname"];
print "<a href='pagename.php?hotelid=$xhotelid'>$xhotelname</a>";
print"<br>";
}

For instance a message such as: "Sorry, but no record has been found".

Please help me out.

Regards,

shailen

[bretticus]

shailen wrote:

Hi,

Could you please place a code in the code below so that if no record is found, a message will be displayed that no record has been found?

$result = mysql_query($sql) or die("hotelid");

$num_rows = mysql_num_rows($result);

if (!$num_rows){echo "sorry...yadda, yadda";}