How do i display a neat table of returned mysql data?

From:	Dave Carrera	Date:	Wed, 30 Nov 2005 05:59:26 +0000
Subject:	How do i display a neat table of returned mysql data?
Groups:	php.general
Request:	Send a blank email to php-general+get-226619@lists.php.net to get a copy of this message

Hi List, I have some mysql table data that i would like to display back to the web user in a neat and tidy way using php. Data: col1 col2 col3 test 1.99 F test 1.99 F test 1.99 F test 0.99 F test 1.99 F bang 2.99 F bang 3.99 F bang 4.49 F bang 2.99 F bang 2.99 F Table display i am hoping to display: First the unique name of col1 as a header <table><tr><td>test</td><td>bang</td></tr></table> Second a row each for each col2 and col3 where header above = col1 so the finished table looks like this

test               bang
1.99   F        2.99   F
1.99   F        3.99   F
1.99   F        4.49   F
0.99   F        2.99   F
1.99   F        2.99   F

I will really appreiciate and help you may give with this question. Thank you in advance Dave C