Before popup check if IP existed in DB

[Anon]

Hi there,

I'm working on the servey. And I'm attatching the survey to the main page. But what I want is:

Get the IP from the database

If it exists then compare the time NOW()
to database entry

if NOW()>1hour the popup survey window
else
go to main page

I try to do this but wasn't able please give me the syntax for that.
Thank you

mannu

[hessian]

/This is assuming you are using the Unix time stamp and MySQL. /

$lasthour = time() - 3600;
$sql = "select time, ip from your_table where time > $lasthour and ip = '$ip' order by time desc";
$res = mysql_db_query("localhost", $sql);
if(!mysql_fetch_array($res))
{
echo "<script language=\"javascript\">\n";
echo "\twindow.open('yoururl')\n";
echo "</script>\n";
}
$now = time();
$sql = "insert into your_table (time, ip) values ('$now', '$REMOTE_ADDR'))";
mysql_db_query("localhost", $sql);

Probably better ways to do it but that should work.

[Anon]

It dosen't work for me, even though I'm using the PHP,Mysql, and UNIX.

It is doing both redirects and opens the survey.

[Anon]

Hi, It dosen't work for me, even though I'm using the PHP,Mysql, and UNIX.

It is doing both redirects and opens the survey.