I have a table called clients. In the table I have two date fields date and date2. I want date2 to equal whatever date is entered into date plus 1 month.
suggestions?
Why do you want to store the same data twice? You can have PHP calculate the value for date2 on the fly after retrieving date from the database. I think it’s possible to have the query calculate the value for date2 for you, but I don’t know the exact function. Check up on the UPDATE query syntax in your database’s manual.