Display results in MySQL between 2 dates [SOLVED]
Posted: Fri May 11, 2007 12:54 pm
Hello again,
Quick question, how do i run a query in MySQL so i can display items that are between two dates?
for example, todays date, and 7 days later?
I saw something similar to this however it wont allow it to run as it comes up with an error.
Basically i am trying to dislay titles that are going to be released within the next 7 days.
Any help is much appreciated, Cheers
Quick question, how do i run a query in MySQL so i can display items that are between two dates?
for example, todays date, and 7 days later?
I saw something similar to this however it wont allow it to run as it comes up with an error.
Code: Select all
SELECT * FROM t1
-> WHERE (t1.soon > 'CURRENT_DATE');Any help is much appreciated, Cheers