On Fri, 8 Feb 2002, Dennis Moore wrote:
> 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.
Actually, you don't need quotes around the col. names at all...
mysql_query("INSERT INTO ips (ip) VALUES ('$REMOTE_ADDR')");
As for only getting the first part, are you sure the ip field is big enough?
Try "explain ips" from a mysql client...it should be at least 15 chars.
Matt
>
> /dkm
>
>
> ----- Original Message -----
> From: "Leif K-Brooks" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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?
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
