store procedure/export data to HTML

[bruce evans]

Hi there,
I need to export a list of queries to multiple HTML files, and I am looking for a short way to do it. Right now, the queries are the same except the value of their condition: like below

select * from mytable where myFig = '1'; -------> export to 1.html
select * from mytable where myFig = '2'; -------> export to 2.html
......


I am using EMS MySQL Manager Pro, and I have to do more than a thousand time to get all HTML files that I need. Since these data are frequently updated, I have to export the files in a period of time basis.

Would anyone please suggest a better and save-time way that make the display of multiple queries and export data to HTML files? If you give me an example or show me a tool to make it happens, it would be great.

Thank you.