Problems with PHP & Dates

[helpmeplease]

Hi,

I'm having some problems creating for PHP a SQL statement, which will allow me to do the following:

My database currently contains a column labelled expiry_date. I would like the PHP script to select particular records, which are within the 30 day(s) of the date specified in the expiry_date column.

for example : today's date 2002-10-22

trigger record if a date up to 2002-11-22 is within the expiry_date column

Can anyone help?

[Quevas]

You should try extracting dates from DB and converting them to timestamp.
Then compare dates extracted and your date taking only those which difference is over 30 days.

I guess SQL is better and faster, but I don't know the right sintax.

Hope this helps.

[[deleted]]

I suggest you read the mysql manual about it's date and time functions, in particular about DATE_SUB() and DATE_ADD().

An alternative is ofcourse to just generate a date 30 days after the dat you are looking for, and selecting all records WHERE exp_date > your_date AND exp_date < (your_date + 30 days)