Re: Trying to put ips into database
| From: | Dennis Moore | Date: | Fri, 08 Feb 2002 17:51:07 +0000 |
| Subject: | Re: Trying to put ips into database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-84019@lists.php.net to get a copy of this message | ||
Not sure what your exact problem is but I did notice you had back ticks(`)
in your insert statement. You should be using ('). You may need a where
clause in your insrt statement unless you want to populate all rows. Just a
couple of thoughts.
/dkm
----- Original Message -----
From: "Leif K-Brooks" <eurleif@buyer-brokerage.com>
To: <php-general@lists.php.net>
Sent: Friday, February 08, 2002 11:18 AM
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?
>