Hi Clint, Another possibility is to actually run the mysql client with a --html option and let mysql do the work for you
eg : prompt $ echo "SELECT some_stuff FROM table" | mysql -u xyz -pxxx --html This generates a block of html for a table with the data encapsulated within, then it is just a matter of capturing the output and putting it in the html stream. You can also generate xml the same way. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: clint lenard [mailto:[EMAIL PROTECTED] Sent: Friday, 9 September 2005 3:31 PM To: mysql@lists.mysql.com Subject: HTML in MySQL? Hi guys, I'm fairly new to MySQL and I've searched for about a week looking for an answer to this... I'm trying to design a Database that would hold HTML sites in the DB itself and use PHP to call for the HTML file - which would be populated with Content from another table in MySQL. I was told I could put HTML into MySQL... so my main question would be: "is this possible?", "is this a BAD thing?" but most of all... would this be resource intensive? Thanks for any answers! I hope I'm using this list correctly - I did search Google and I've been reading an MySQL Manual for over a week now trying to get it down 110%! Thanks, Clint -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
