On Thursday 07 February 2002 02:16, Todd Williamsen wrote:
> I have done a search page based on a specific column name, but in some
> columns there is no results to be returned..
>
> What I would like to do is display an error message stating that there is
> no results .. something like "Sorry your search returned Zero Rows"
> =============================================================
> Here is my code:
>
> <?
> $connection = @mysql_connect($databaseserver, $databaseuser, $databasepass)
> or die("Can't connect to DB");
> $db = @mysql_select_db($databasename, $connection) or die("could not select
> DB");
> $sql = "SELECT id, FirstName, LastName FROM Canidate WHERE Industry =
> \"$Industry\"";
> $result = @mysql_query($sql, $connection) or die("could not execute
> query");
>
> $contact_list = "<ul>";
> while ($row = mysql_fetch_array($result)) {
$FOUND_SOMETHING = 1;
> $id = $row["id"];
> $FirstName = $row["FirstName"];
> $LastName = $row["LastName"];
> $contact_list .="<li><a href=\"show_can.php?id=$id\">$LastName,
> $FirstName</a>";
> }
> $contact_list .="</ul>";
> $msg = "<font face=\"arial\"><p align=\"center\">Sorry, Your Search Results
> Returned Zero Records</p></font>";
> ?>
>
> <html>
> <head>
> <title>Your Search Results</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
>
> <body>
> <p align="center"><font face="Arial, Helvetica, sans-serif"><u>Your Search
> Results
> for <b> "
> <? echo "$Industry"; ?>
> " </b></u></font></p>
> ========================== this is the code block that is stumping me
> <?
> if ($FOUND_SOMETHING) {
echo "$contact_list"; }
else {
echo "$msg";
> }
> ?>
> ================================
> <p align="center"><a href="admin.htm"><font face="Arial, Helvetica,
> sans-serif">Go
> Back to Main Menu</font></a></P>
>
> </body>
> ==============================================================
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Lonely is a man without love.
-- Englebert Humperdinck
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
