Seach IP in field actionate

Anon

How can i search a field in mySQL for an ip adress?
On my site visitors can comment but i only want them to comment only once.
So when the page is loaded, the script had to look for an IP adress in table REMOTE_HOST...
I can get the data out of it, but i want to have an if statement when the IP is there or not.

But how i don't know..
Please help.. Thx in advance 🙂

bastien

Why are you using IP. Most people still use dial-up and therefore the connection is vairable ( they will not have the same IP each time as the connection comes from a pool the the ISP holds)

But:
Get the Ip from the client
strIP = "select * from myTable where IP = $Ip"
execute the query and check the number of rows...
if number of rows = 1 then
echo"Sorry, you already commented";
else
strIPInput = "insert into myTable(IP)values($IP)";
execute the input
end if

its rough but should point you in the right direction...

Bastien

Anon

Ok thx very much. I want to use cookies l8r when this works..
I think it should work like this, but it doesnt. Can you see whats wrong?

<?php
$db = @mysql_connect("localhost", "", "");
mysql_select_db("***", $db);

$ip=getenv(REMOTE_ADDR);
$sql = "select * from rates where REMOTE_ADDR = $ip";
$result = mysql_query($sql);
$countd = mysql_numrows($result);

<?php

if ($countd == 1) {

echo "You have already commented";

} else {

echo "Comments:";

}
?>

Anon

REMOTE_ADDR should be a string, not a number, so it should be enclosed in quotes.

Diego