TIME_TO_SEC (mysql)

IWeb

Hello,

I want to check whether an IP is unique or not.
Unique is a time defined in seconds.
The IPs are stored in a mysql database and there is also a column that has the last-visiting time (DATETIME field).

Now I want to check the "uniqueness" of an IP within the mysql-statement.

e.g.:

$uniqueip = 3600;
$ip = "something";

mysql_query("SELECT *... WHERE IP='$ip' AND  (TIME_TO_SEC(NOW())-$uniqueip)>TIME_TO_SEC(LastVisit)");

This should return a result when the IP is unique.

But this does not work.

Any suggestions?

Thanks

Wien

???

For what I understand, your query doesn't check if you IP is unique, but check for a given IP if the last visit was later than one hour ago...
Is it correct ?

IWeb

yes.

Wien

The query seems ok, if it returns nothing it means that the last visit was less than one hour ago...
Try with $uniqueip = 3

IWeb

but when there is a difference of e.g 2 days and 10 seconds, then it does not work properly.

Wien

I think I know why it doesnt work
From the doc :

TIME_TO_SEC(time)
Returns the time argument, converted to seconds:

So you need to handle TIMESTAMP type

this should work
SELECT *... WHERE IP='$ip' AND (UNIX_TIMESTAMP(NOW())-$uniqueip)>UNIX_TIMESTAMP(LastVisit)

IWeb

Thanks!

Now it works.