|
In one of my forms I have a field with the number of days the things in the form should be visible on my website..... how would the MySQL look for something like that.
What i need is something in the direction of current date, and the chosen number of days ahead in the future.
I use this line in a thing that does something simular, but just back in time (my top-links list past chosen number of days)
"SELECT * FROM toplinks WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= date")
|
