I need a script that will take a mysql query that has been entered into a textarea form and parse the results for display in a browser.
Example: someone enters
'select name, address, phone from customers
order by name'
in a textarea field. I want to parse this so that
the results can be displayed in a table with Name as column 1, Address as column 2 etc. I have to be able to also parse
'delete from customers where .....'
or other queries.
I know that this has been done, and rather than
reinventing the wheel, I'm hoping that someone knows of a script that I can get and modify.
Thanks
B