Displaying database info, but not at simple as you think.

[iPixel]

Ok lets say im given 9 sku #'s.

 

for ease lets say they are 1,2,3,4,5,6,7,8,9

for each # i pull info from a database (header, subheader, img, pricetype, price,link)

 

it would be easy to display the date liek so in a table (imagine [] are table cells.

 

[1][1][1][1][1][1]

[2][2][2][2][2][2]

[3][3][3][3][3][3]

[4][4][4][4][4][4]

[5][5][5][5][5][5]

[6][6][6][6][6][6]

[7][7][7][7][7][7]

[8][8][8][8][8][8]

[9][9][9][9][9][9]

 

but what i really want to do is display the date like so

 

[1][2][3]  -  Header

[1][2][3]  -  Subheader

[1][2][3]  -  Image

[1][2][3]  -  Pricetype

[1][2][3]  -  Price

[1][2][3]  -  Link

[4][5][6]  -  Header

[4][5][6]  -  Subheader

[4][5][6]  -  Image

[4][5][6]  -  Pricetype

[4][5][6]  -  Price

[4][5][6]  -  Link

[7][8][9]  -  Header

[7][8][9]  -  Subheader

[7][8][9]  -  Image

[7][8][9]  -  Pricetype

[7][8][9]  -  Price

[7][8][9]  -  Link

 

So you see my dilema, im not sure how to structure a script to know when to put what info in.

 

Also keep in mind the SKU# are passed to this page via form and are stored in an array $a_mdl.

 

Thanks To All Who Help.

 

[revraz]

See if this helps

 

http://www.phpfreaks.com/forums/index.php/topic,95426.0.html

[iPixel]

Almost, the difference is.. he pulls a bunch of items from the database once and displays them

[1][2][3]

[4][5][6]

[7][8][9]

I on the other hand will be pulling from the database from 3 to 9 times.

So that script wont really work for me but it does give me some ideas on how to get started on my problem. Thanks for the quick response, but keep the help coming.

[iPixel]

Yea im not having much luck with that script from the link.