chop Posted April 28, 2012 Share Posted April 28, 2012 After some looking around, I've not been able to print a mysql query of name,address to a sheet of Avery labels. After coming close in Firefox, more tweaking (the css) didn't get me much closer. When I tried it in Safari, it was off by a mile. This makes me think that it's just not the way it's done -hello. Exporting the data base from php admin and then bringing it up in Excel works but it's not practical to have a client try that. Any help appreciated.... Link to comment Share on other sites More sharing options...
Paul Posted April 28, 2012 Share Posted April 28, 2012 Chop, Are you using a HTML table? Paul Link to comment Share on other sites More sharing options...
chop Posted April 28, 2012 Author Share Posted April 28, 2012 Yes I was using a table and some css code that I found but nothing quite lines up and different browsers can throw it way off. Link to comment Share on other sites More sharing options...
HartleySan Posted April 28, 2012 Share Posted April 28, 2012 I've only ever printed out addresses to labels in Word, so I can't really help, but maybe some Web searching will turn up some good results. I have a feeling that that sort of thing is very dependent on the printer you're using, etc. I guess all you can do is print out a couple of samples to normal paper, and try to make the necessary adjustments with CSS. It certainly sounds possible, with some patience and testing. Link to comment Share on other sites More sharing options...
chop Posted April 29, 2012 Author Share Posted April 29, 2012 FYI: some research on this shows that one possibility is to use a php class called fpdf to generate a .pdf file which can then be printed with more reliability when using different browsers and printers. http://www.fpdf.org/ Link to comment Share on other sites More sharing options...
HartleySan Posted April 29, 2012 Share Posted April 29, 2012 Not a bad idea. I imagine PDFs are a lot more consistent in how they're printed. Please let us know what you find. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts