I need to create an SQL query that will either be run on a weekly or monthly basis. The data collected from the query will then be exported in a csv format, then imported into an email marketing program.
The second time the query is run it will only need to retrieve new data that has been entered into the table since the previous query was run, not the data that was already captured from the previous running of the query.
Is this possible and how do I achieve this?
I'm using phpMyAdmin 188.8.131.52 Apache 2.2.11 php 5.3.0 with joomla 1.5