3 things I can think of. None of them really good. 1: VERY BAD Use PHP to generate VBScript to control MS Word. I've actually done this with Excel and while it works, it's not the best solution. (Not by a long shot)
2: BETTER Use PHP to build a PDF on the server in the proper Avery label format and then serve it up through the web server. If you get this working, make sure you share how you did it. 3: Better Use a reporting package. There are several reporting packages for MySQL. Check freshmeat.net or sourceforge.net to find the one best for you. Finally, if the user is local, simply output the labels to the proper LPR/LPD or CUPS device. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * ----- Original Message ----- From: "Landy Atkinson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 27, 2003 2:25 PM Subject: Mailing Labels from MySQL database on web > I have a club roster database set up on our web site in which the > underlying data is in a MySQL database. I am using PHP to access the > data and display it on a web page as a phone list, e-mail list, > directory etc. Now what I need it to give the club secretary a way > to print mailing labels. > > What is the best way to approach this? As a temporary measure, I > used an auxiliary program (MySQL-Front running on a PC) to create a > CSV file on my PC which I e-mailed to the secretary along with > instructions on how to use the file in mail merge document in MS Word > to create labels. I thought about writing PHP code to create a CSV > formatted output on a web page which the secretary could copy and > paste into a document for the mail merge, but it seems there should > be a better way. > > Any suggestions? > > -Landy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
