Jun 3rd, 2009, 8:28 PM
Neat problem!
Generating the table with the data isn't tricky at all, but including rows for rooms that don't have any problems reported makes it a little more difficult.
Hmm... I think you'll probably need to write a custom PHP page for this. It's a drag, but I can't see a way around it. In broad terms, I'd do this: in your PHP create a single array storing all 20 room numbers. Then, loop through each, querying the database for any info for that room number. For each item, if there's no data, just output an empty row.
Sorry this is so very general, but If you need some more help, let me know! :-)
- Ben
Generating the table with the data isn't tricky at all, but including rows for rooms that don't have any problems reported makes it a little more difficult.
Hmm... I think you'll probably need to write a custom PHP page for this. It's a drag, but I can't see a way around it. In broad terms, I'd do this: in your PHP create a single array storing all 20 room numbers. Then, loop through each, querying the database for any info for that room number. For each item, if there's no data, just output an empty row.
Sorry this is so very general, but If you need some more help, let me know! :-)
- Ben