[MySQL] Interval from date?

[Superfun]

mysql_query("DELETE FROM heartbeat WHERE when + INTERVAL 25 SECONDS < NOW()");

(the when row is a datetime row)

What am i doing wrong here?

 

[onemorejosh]

I don't know mysql, but you could try these two variants.

In postgresql, it would be exactly like you did it, except with single quotes around 25 seconds:
mysql_query("DELETE FROM heartbeat WHERE when + INTERVAL '25 SECONDS' < NOW()");

In mssql, treat it like a float with 1.0 being 1 day
mysql_query("DELETE FROM heartbeat WHERE when + 25.0/60.0/60.0/24.0 < getdate()");
or
mysql_query("DELETE FROM heartbeat WHERE when + 25.0/60.0/60.0/24.0 < now()");
(25 seconds, divided by seconds in a minute, minutes in an hour, and hours in a day)

 

[passie]

mysql_query("DELETE FROM heartbeat WHERE when + INTERVAL 25 SECONDS < NOW()");

(the when row is a datetime row)

What am i doing wrong here?

Well first thing maybe it smart to explain what your trying to do...

i got a example query maybe thats helps you ..

mysql_query("select * from `users` where `online`>DATE_ADD(NOW(), INTERVAL -5 MINUTE)");

~Passie

 

[Superfun]

Well first thing maybe it smart to explain what your trying to do...

i got a example query maybe thats helps you ..

mysql_query("select * from `users` where `online`>DATE_ADD(NOW(), INTERVAL -5 MINUTE)");

~Passie

Thanks, that helped me.

 

[passie]

Thanks, that helped me.

Your welcome.
feel free to pm me anytime if you need php help!

~passie