I have a property website, which already has some extensive search criteria for users to filter which properties they would like to see.
I need to add to the search queries that fact that only properties which are within 21 days from the date they were submitted should show up!
I have the following column on my mysql db: add_date which is datetime type.
I think I need to write something like:
echo date("d/m/y", strtotime(0,0,0,date('m'), date('d')+21, date('y'));
However it is not really working. And I'm not sure where to put it in the sql query?
Any help would be great! :-)