Results 1 to 3 of 3
  1. #1

    MySQL & Avery Labels

    Hello!

    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
    Location
    Athens, Greece
    Posts
    1,479
    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
    Location
    Dayton, Ohio
    Posts
    4,962
    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
  •