First off: My database has 625 records and is set out like: Column Name: World | Quadrant | SHC1 | SHC2 Records: 1 | 1 | 1 | 1 1 | 1 | 1 | 2 1 | 1 | 1 | 3 until... 1 | 1 | 1 | 25 1 | 1 | 2 | 1 1 | 1 | 2 | 2 1 | 1 | 2 | 3 until... 1 | 1 | 25 | 25 SHC1 is the '15' in the coordinates '15:10' SHC2 is the '10' in the coordinates '15:10' I want to Put all the data from that mysql table into a (HTML) table similar to the one that I attached in Excel Format. (This would be done by PHP) If you can help, and if this made sense it'd be much appreciated. I know this is confusing, but if you can help it'd really be awesome
Looks like homework to me Just loop through the result set and save certain values to $oldSHC1 (for instance) and when $oldSHC1 <> $row['SHC1'] echo out the code to end the table row and start a new one.