Extracting information form the database

[denzaldog]

I'm just hoping that some one can point me the right direction here. What I need to do is extract order information for the last 12 months on my shop. Using the products table I have been able to download the entire database since the shop opened in 2006 but I'm now required to supply data from just the last 12 months I've searched through PHP My Admin but can't find any settings that might help - any advice would be great - Many thinks

[burt]

select * from 'orders' where 'date_purchased' >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)

[denzaldog]

Thanks for this. If I use the drop down box and just change the Type field to YEAR will that have the same effect? Will I loose any older information if I make this change?

[denzaldog]

If I use this function will it be applied to the entire database? ie I want to apply the year rule to the number of each product purchased in the last year but I also need to included cost price / selling price / manufacturers product Id and product name. All of these fields appear under the products table - Hope that this makes sense :)