Hi all.
I currently have a database that stores various details relating to each day in a business. I want to be able to take the last date something was entered and display a form for the user to enter the details for the next seven days.
I have selected the most recent value from the database, which is of type date("Y-m-d"), but now I cannot work out how to increase it.
I have tried to add 1 but that increases it by 1 year, I have tried to increase it by seconds but as it's not a timestamp that doesn't work. I have searched around for a while and had no luck.
So I have considered splitting up the date, increasing the day value and putting it back together, but before I try that does anyone have any suggestions?
Thanks very much,
Dan