On Fri, Feb 29, 2008 at 12:22 AM, Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx> wrote: > $reference_number = mysql_result($search_result,$i,"reference_number"); > $description = mysql_result($search_result,$i,"description"); <? $sql = "SELECT reference_number FROM table WHERE this='whatever' OR that NOT LIKE '%whatever%' LIMIT 0,1"; $result = mysql_query($sql); $row = mysql_fetch_array($result); ?> Just mind the line-wrapping in this message. ;-P -- </Dan> Daniel P. Brown Senior Unix Geek <? while(1) { $me = $mind--; sleep(86400); } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php