Thanks for responding Steve, My error reporting is turned on, because I always get errors. I found the problem, I had two ;; at the end of one of the statements.
Thanks- Andrea -----Original Message----- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 10:27 AM To: Andrea Caldwell Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] elseif statement syntax You probably have error reporting turned off in your php.ini file or you may be directing errors into your log file, try checking there. Why are you tacking "or die(mysql_error())" on the end of each of your query assignments? You're just assigning a string to a variable so there's nothing to fail, or at least no mysql errors. -Steve On Wednesday, March 20, 2002, at 10:41 AM, Andrea Caldwell wrote: > Hi All, I'm pretty new at this, so go easy on me please ;-) > > What is wrong w/ this syntax? If the search results are 0, it just > displays > a blank screen instead of echoing the error message if numresults ==0 > or the > mysql_error message. If data is found, everything is fine. Thanks in > advance for your help! > > if($searchterm){ > $query = "select directory.realname, directory.phone, directory.ext, > directory.phone2, directory.email, directory.location from directory > where > realname like '%".$searchterm."%'" or die (mysql_error()); > } > elseif($location){ > $query = "select directory.realname, directory.phone, directory.ext, > directory.phone2, directory.email, directory.location from directory > where > location like '%".$location."%'" or die (mysql_error()); > } > else{ > $query = "select directory.realname, directory.phone, directory.ext, > directory.phone2, directory.email, directory.location from directory > where > location like '%".$searchloc."%'" or die (mysql_error()); > } > > $result = mysql_query($query) or die (mysql_error()); > $num_results = mysql_num_rows($result)or die (mysql_error());; > > if($num_results==0){ > echo "Sorry, nothing matched your search request. Please go back and > try > again."; > } > > else { > echo "<p><span class=stdtext_bold>Number of Entries Found: > ".$num_results."</p></span>"; > } > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
