Reading data from a MySQL database into a HTML Table?
- by Michael McKay
So i am working on a project and need some advice.
I have a MySQL database that stores events, i know how to code this functionality in PHP but im just stuck of a few specifics.
As the project that I am creating is a timetable, the most important attributes are the day of the event, starting time and finishing time.
Once i have read this data from the MYSQL database using my PHP script, how do i go about inserting these events in to a html timetable?
Lets say i have record like below in my events table:
Event ID = 01
Event Day = Monday
Event Start = 12:00
Event End = 14:00
How would I then put that into a html table, bearing in mind that i may have mutiple events for a day?