i know im close to what i want but cant get it right
here is what i have, user logs in and time() unix timestam is recirded, now i wan to find out who loged in within last 30 sec so i do:
SELECT * FROM users WHERE timestamp >= ROM_UNIXTIME(0)-30;
But that doesnt work...