Re: Trying to put ips into database

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" <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? > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >