Hello..
I have some information organized in a database table like this
Name | Column | Position
-------------------------------------
Pete 1 1
Chuck 2 1
Peter 2 2
Paul 2 3
Mary 1 2
Clary 1 3
And I need to make an html table that is ordered by those positions in those columns as above. An example of what my html table would have to be with the dat a above would be::
Pete | Chuck |
Mary | Peter |
Clary | Paul |
I'm wondering what would be the most efficient way to get the data out of database table, and organize it into the dynamic html table.
Right now I'm thinking going to read everything out of the database table with column=1,then build the html table...then read everything with column=2 out of the dbase table, and modify the DOM with javascript to build the other column of the html table.
1. Is this a good way to go?
2. What other options do I have to build it like this?
3. What is the fastest way to do it? This table is rather large, and i'm concerned about the page load time.
As always.., ratings to the helping hands ;-)
Thanks,
ArchG