Results 1 to 3 of 3
  1. #1

    MySQL & Avery Labels


    After scouring Google for answers, I have resorted again to asking in the only place I find REAL answers : WHT.

    I have a populated MySQL database with client contacts, in FirstName, LastName, Address1, Address2, City, StateZip format.

    I also have an extremely simple barebones PHP script that spits out the information in a format appropriate for postal mail.

    I need to find a way to layout the results in a 3 column format that is compatible with Avery Label standard 5160, or others that we can come up with and I don't mind buying new labels to match.

    Any ideas?

  2. #2
    Join Date
    Jan 2006
    Athens, Greece
    Have you tried tables?
    Measure the size of the sticker label and make this size the td's size.
    If you do the table 100% width it will be automatically adjusted for the print page.

    Or simply use tabs ( chr(9) ) and <br/> 's.

    On the table you will have to loop and change <tr> every 3 items (data structure)

  3. #3
    Join Date
    May 2001
    Dayton, Ohio
    Usually Avery will have a template for Microsoft Word than you can use. I would pull the data from your database in CSV format and bring it into Microsoft Excel and do a mail merge on the Word template.
    -Mat Sumpter
    Director, Product Engagement
    Penton Media

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts