The script needs to access a database in MySql, select from 3 tables certain information and display the contents of that search criteria grouped by date. The content displayed will then need to be Exported to a csv file.
The search function will need to search the tables by date. The user will type in a date or use a date picker as the search criteria. Either a single date or a date range. Defaulting to today's date.
There will need to be a user name and password hard coded into the script for security purposes.
The script should be optimized so as to not put any undo cycles on the server.