Trying to set up data synch between our internal DB and a db on our webserver. (one way synch)
I set up the sync with the wizard, and on some of the tables I added this WHERE statement “startdate > CURDATE()”
because we don't want to show OLD information on the webserver just data for days after the current date.
But what seems to happen is that each time the script runs, it doesn't remove the information where startdate <= curdate()?
Is this how it should function or am I missing someone.
Thanks,
-David