I have some questions I thought people might be able to enlighten me on. I have a database of website content that I have inherited that is full of standards-killing html (about 500 website pages; long story). I would like to change that, but its a job that is a little too big for one person. That's why I thought I might be able to enlist the help of html tidy, the nifty command line tool.
Under normal circumstances html tidy would be utilized in a loop to go though a directory. Like so:
#! /bin/sh for a in 'ls -l *.html' do cp $a $a.bak tidy $a > $a.new mv $a.new $a echo "$a is done!" done
But since all the content is in MySQL, and I'm a newbie to such things as the command line, MySQL, and PHP I'm pushing my limits here (which is, of course a good thing!). I was curious if anyone could help me out by pointing me in the right direction on how I get the data out of the database (and back in) so that Tidy can work on it -- or get HTML Tidy into the database.
Thanks!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
