Posted by Dave Carrera on 11/30/05 07:59

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

[Back to original message]