Exporting results data

H

Hugh

Guest
Is it possible to export results of a search or show-all records to other formats? i.e. to Excel, or even as an html table?

What do you do if you want to print these query results, other than just printing the whole browser screen?

Hugh

(sorry....questions, questions, questions!!)
 
E

egr

Guest
mysql command line + tee to a logfile :)

Better, try phpmyadmin.

egr.
 
H

hugh

Guest
Don't understand mysql commands - haven't learned them.
PHPMyAdmin too slow and requires direct login to database. Also doesn't produce an Excel file, only CSV.

This is for client use and much easier for them to stay within one programme than have to use two or three complex ones like PHPMyAdmin - they know nothing about PHP and shouldn't need to; they just want to access their data.

I have since found a little utitlity script called <b>Dynamic Excel or Word file from MySQL</b> (http://www.churm.com) at Hotscripts which does an excellent job. Something like this built into DaDaBik would blow other database abstractors away!
 
Top