data calculation in PHP

[netkwake]

I am currently storing quotes in a mysql database using a standard Y-m-d (2007-05-23) format.

I want to be able to produce a list of quotes from the database but only ones which are less than 365 days old.

To produce the list is easy

select * from quotes

but how do I limit it by date based on my current method of storing the dates?

Its probably really easy but help would be appreciated. I have checked the PHP site but can't seem to find something that exactly fits the bill.

[spikeZ]

Let mysql do the work for you rather than php.

select * from 
	quotes
where
	DATE_SUB(CURDATE(),INTERVAL 365 DAY)

REF: http://dev.mysql.com/doc/refman/5.0/...ction_date-sub

[netkwake]

Thanks for the reply, unfortunately I think I must be in ultra thick mode today because despite the logic of your reply I can't make it work.

The quotes table has a date field so if I wanted to select a quote by date I would use the query -

select * from quotes WHERE quoteDate = '2007-08-09' or something like that.

What I actually want to achieve is a similar statement but selecting all quotes where the date is less than 365 days old but the month = "July". So I need to be able to check other parameters as well as the 365 days bit, therefore I don't think the date_sub function does it. (The reason for the 365 days bit is because the database has been running longer than a year and I need to limit search by month queries to a maximum of 12 months or 365 days to keep it within the current trading period).

I didn't explain myself very well the first time around, hope this is better.

Thanks again