populating tables

[cbesh2]

I'm trying to populate an HTML table using the data in MySQL. My question is "how to do format it to where I can make shipping labels?" There will be three lines of text for each label but I will have three columns of labels X 10 rows.

line A1     line B1     line C1
line A2     line B2     line C2
line A3     line B3     line C3

line D1     line E1     line F1
line D2     line E2     line F2
line D3     line E3     line F3

....
....
....

I'm not sure where to start. Can somebody point me in the right direction? Thanks for your help in advance.

[troybtj]

Run your query to get your list, store into an array since the values you need aren't going to come out in the order you need.

In a hurry so all this is sloppy psuedo-code

so a foreach loop to store array[1][name/addr/city/zip], array[2] to store name/addy/city/zip] for three rows from the query.

Then you can use

<tr><td>array[1]['name']</td></td>array[2]['name]</td><td>array[3]['name']</td></tr>
<tr><td>array[1]['addr']</td> ....
...

etc.

Then get the next 3 rows for shipping, you will probably have to do some width settings in pixels on the rows and data cells for it to print correctly.

Loop through above 10 times.