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:clint.lenard@stripped]
Sent: Friday, 9 September 2005 3:31 PM
To: mysql@stripped
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
