I need some help. I want to get rows from a db that are up to 30 days old. I have a column called joindate which is a date type. I want to do something like this but I dont know the synatx:
SELECT from table WHERE joindate - NOW() = 30 60 60 * 24.
I suggest you read your database's manual, will contain a sh*tload of usefull functions.
For example, MySQL hase date_sub() and date_add().
Manuals are your friends, read them.
