Glad to hear :-). For those who may be interested, FWIW I actually run a lot of php stuff from the command line, it's quite useful in situations like this if you want to log stuff to a db and extract data from a db etc.. one of the many cool things about php is the fact that theres a php executable which you can point at a php page and it does the business, it may not be as fast as using perl or other tools, but the flexibility and ease of writing php scripts makes up for it :-)
jeremyb. > From: Barry <[EMAIL PROTECTED]> > Date: 2002/07/31 Wed PM 10:16:34 GMT+12:00 > To: Jeremy Bertenshaw <[EMAIL PROTECTED]>, > 'clug' <[EMAIL PROTECTED]> > Subject: Re: MYSQL HTML OUTPUT > > 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 > > > >
