What type of field is 'ip'? Matthew Walker Ecommerce Project Manager Mountain Top Herbs
-----Original Message----- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: [PHP] Trying to put ips into database I'm trying: $query = mysql_query("select COUNT(*) as rowexists from ips where ip = '$REMOTE_ADDR'"); $result = mysql_fetch_array($query); if($result['rowexists'] == false){ mysql_query("INSERT INTO `ips` (`ip`) VALUES ('$REMOTE_ADDR')"); } But it keeps putting the ip into tthe array, even if it's already there, and it only gets the first section of the ip! What am I doing wrong? --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php