| not experienced enough to figure it out. I simply want to grab every entry
| in a given table that has been entered within the last three days.

select * from yourtable where datefield < date_sub(now(),interval 3 day);

see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html

ati

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to