> Has nothing at all to do with php. > > http://dev.mysql.com/doc/refman/5.0/en/datetime.html > http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html > > Yeah guess I posted to the wrong list should of been on the php-db list maybe but thanks for the suggestions Marc I'll be trying yours out and also going to try *SELECT DATEDIFF('stamp','NOW()')= 7d; or something somehow like that... *