print labels?

[Bluelove]

How can i print labels from a mysql db in php?

say like i have these rows in it
number of labels to print, product name, category, price

How can i fetch all and display so php should print into a A4 page wich contains 3 coloms of 7 labels?

so if i have like in my database the following data
5 Mug 5
7 Cup 8
8 Coffee 3

php will display a page with

Mug 5 Mug 5 Mug 5
Mug 5 Mug 5 Cup 8
Cup 8 Cup 8 Cup 8
Cup 8 Cup 8 Cup 8
Coffee 3 Coffee 3 Coffee 3
Coffee 3 Coffee 3 Coffee 3
Coffee 3 Coffee 3

wich i then can print

anyone a suggestion?
thx

[barand]

I always generate PDF docs for printing using FPDF . It's fairly easy and it's free. Plus it gives the option of previewing, printing or saving.

[Bluelove]

thx
but anyone another solution?
cause i gotta fetch some results from the database to display this in the labels
?