Remove the @ in front of the mysql_num_rows function call. The @ symbol supresses errors, so that's likely where your error would be printed.
Cheers - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 1:15 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] I'm less experienced please be gentle :) Can anyone tell me whats wrong with the below code? it doesnt execute. $ip=$_SERVER["REMOTE_ADDR"]; $banned="SELECT * FROM banned WHERE ip='$ip'"; if(@mysql_num_rows(mysql_query($banned)) > 0) { echo "You have been Banned."; }else{ echo "$ip"; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
