new php based view to sql table

Write php web page and mysql query that will show a view (or new temp table) that will show each machine from table dsp with the most recent recorded time of table reg. two tables are in database qxdsp table ‘dsp’ -is a list of all devices(compters) their id field is ‘ho’ ‘reg’- is periodical connection entries that gets created when each of these devices connects to my network with a time stamp. The machine id here is 'dspid' which will match 'ho' from table 'reg' I want to be able to display the last contact time of all the devices listed in my devices table in a list by Machine name from table 'dsp' and show this as a webpage result. Please see attachment for further details and an example of what I require ## Deliverables please see attachment for 'mockup' example ## Platform firefox