designing and printing labels? please help

[LordMerlin]

I'm not sure whether this is a Java / Java SCRIPT / PHP question, but let's try Smile

We're busy developing an in-house CRM / ERM, and we need to be able to design and print label for pill dispense bottels.

Our requirements are as follows:
Design the general label layout, including size and text. Graphics isn't really needed.
Add info from a MySQL DB to the label, like patient name, medication / drug info, etc
Print it via a webpage.

Java would probably be the best, though I don't know Java, but I'm sure I can get to grips with it Smile The system is written on in PHP, with a MySQL DB, and runs off a Linux server. But we'll have Windows & Linux PC's connecting to it via the web (on a VPN) using firefox.

Any suggestions, resources, info?

[dalecosp]

Main thing, I suppose, will be CSS for formatting, albeit there may be other over-arching issues.

Hrm, but then again, I'm thinking on the client. If the Linux box is the printer server, then it's probably simply a matter of creating files in the proper format and having the Linux box print them out.

Sounds interesting, to say the least....