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