Code: Select all
db that have been posted in the last 5 minutes, the form is a timestamp(14) i.e. 20050606163000 = june 6 2005 4:30 - anyways - hows it done?Moderator: General Moderators
Code: Select all
db that have been posted in the last 5 minutes, the form is a timestamp(14) i.e. 20050606163000 = june 6 2005 4:30 - anyways - hows it done?Code: Select all
SELECT *
FROM table
WHERE WHERE DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= timestamp