mysql timestamp problem
#9

Код:
"SELECT  *, UNIX_TIMESTAMP(Expire) AS expire_unix FROM vips WHERE Vipas = '%s'"
Then fetch `expire_unix` and commpare with gettime().


However, even better solution is this (for advanced users):
Код:
DELETE FROM vips WHERE Vipas='%s' AND NOW() >= Expire
Then simply check with mysql_affected_rows if there were any rows deleted and make your changes in PAWN.
Reply


Messages In This Thread
mysql timestamp problem - by Vivaz - 10.03.2013, 21:28
Re: mysql timestamp problem - by IceCube! - 10.03.2013, 21:30
Re: mysql timestamp problem - by Vivaz - 10.03.2013, 21:35
Re: mysql timestamp problem - by Vivaz - 10.03.2013, 22:34
Re: mysql timestamp problem - by Vivaz - 11.03.2013, 10:10
Re: mysql timestamp problem - by Djole1337 - 11.03.2013, 10:27
Re: mysql timestamp problem - by Vivaz - 11.03.2013, 10:29
Re: mysql timestamp problem - by Vivaz - 11.03.2013, 10:40
Re: mysql timestamp problem - by Sergei - 11.03.2013, 10:54
Re: mysql timestamp problem - by Vivaz - 11.03.2013, 11:17

Forum Jump:


Users browsing this thread: 4 Guest(s)