Mysql query question

nca

SELECT * FROM table WHERE PHOTO=1 AND SOLD=2 ORDER BY RAND() LIMIT 0,1

is there any way to query this statement and only have it choose from the last 90 days worth of records, instead of choosing the information of any random record?

there is a date column in the database, it is in 2002-01-30 format.

please let me know.

thanks!

Krush019

Here's an idea. Use getdate() to get the current $date. Do the math changing the $date to 90 days ago. Add an "and where" to your query using the new $date. I'm a rookie but thats what i would do. You can find out more about getdate(), if needed, from the php manual on php.net.

nca

🆒 I think i have figured it out on my own!! 🆒

SELECT * FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(ADDED) <= 90 AND PHOTO=1 AND SOLD=2 ORDER BY RAND() LIMIT 0,1

Krush019

Nice, i've never seen to_days before, so we both learned somethin! 🙂