I am building a Intranet app. for a bowling alley. The idea is to make reservations thrue the intranet using PHP and MySQL.
Its already working... and they use it with great pleasure.. however its SLOW as hell (5 seconds execution time and more)
This is what it looks like:

As you can see, its just a table.. it fills the TD's with reservations, and the little arrows are to make one at a time and a lane. As you can see it already uses COLSPAN to create a larger reservationblock, but doesnt seem to work well with ROWSPAN (i really want that to work aswell)
The script is bloated. I used ALOT of whiles and ifs to make this work.. at one point there are 5 or 6 loops running at one time. (:( ) anyways.. i need to get this faster..
This is what the database table with reservations looks like:
| ID | ClientID | Date | Time (used as 2-2.5-3-3.5 for 14:00 to 16:00) | Lanes (looks like 1-2-3-4 for the first 4 lanes) |
Hope you can help me with making a whole new function to get the data out of the database, and parse a TABLE with the reservations!
Thanx in advance..