如何使用MySQL的5个不同结果集填充HTML表格中的5个不同列

Question

I have a table with the following structure, let's name the header with letters:

A | B | C | D | E

I would like to perform 5 different queries to my mysql server and I would like to fill the whole table with them in the following way:

The first result-set to complete the whole A column, then with the other result I would like to complete de column B, and then the 3 that left.

If I use a for statement, the for fills them in that way: After I echoed the table headers, it begins filling the SECOND cell of column A, then the SECOND cell for column B, then the SECOND cell of C until it completes the whole row.

And what I do want is to complete the first cell of column A, then the second cell of column A, then the 3 cell of column A and so on.

When I completed the whole column. I would like to complete the column B, then C, D, and E.

I hope I was clear enough.

I would like to implement this with PHP and using a for loop.

Answer 1

I just posted an answer and example code to a very similar question. It assumes you have only 1 data set, but want to display it in columns. You can find that answer here: Is it possible to fill a table with values in column wise? If you like the answer, please vote it up.