Thank Jeremy Read a different part of the instructions this morning = problem solved by using a bash script to read the db and write a html file to pass via html2ps to the printer. With the aid of another script the whole lot runs in the background very nicely so far. It does not use php.
Barry --------------- Jeremy Bertenshaw wrote: > > Why not run your php script from the cmd line and pipe > it to htmltops? that way you can control the formatting > better :-) > > jeremyb. > > > From: Barry <[EMAIL PROTECTED]> > > Date: 2002/07/30 Tue PM 09:21:00 GMT+12:00 > > To: 'clug' <[EMAIL PROTECTED]> > > Subject: MYSQL HTML OUTPUT > > > > The html2ps utility works fine but does not interpret php code, it does > > not run via apache. > > > > To extract table data I must run mysql in batch mode ie *mysql -H < > > batchfile > *.html' from the command line. This will output in html > > table format but with only one line per row. > > > > What I am getting is:- > > > > <TR><TD> > > field 1 > > </TD></TR> this line should be </TD><TD> > > <TR><TD> making this line redundant > > field2 > > </TD></TR> > > field1 > > </TD></TR> > > ....etc > > > > What do I do to get a multi column table correctly described in the > > output file? > > > > can anyone help please > > > > Barry > >
