php - create report from mysql database table

php - create report from mysql database table the report should be in .php and run in a web browser etc The report will take two parameters ( imei number and a date range ) and will be called like www.mywebsite.com/reports/report.php This will first load all available imei numbers from database and some date options like today, yesterday, this week , last week and/or allow 2 dates to be selected from a calender date_from and date_to the main table of interest contains history information of start/ stop times for a particular device imei number the report should be in a Tabular format with the start_time first etc and details of journey time (minutes or hours etc) displayed. A filter should be used that if the calculated stop time is less than eg 5 minutes, then its filtered out of the report as a journey... see also atchd for sample data etc