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

Reply via email to