I'm creating a custom application in php/MySql which allows users to create and edit their own db table views using a gui with text boxes, pull downs, etc.
One big challenge at this point is in editing the views. When they create a view, it will be easy enough to concatenate field names, ><= operators, etc. into a sql statement, which will be saved into a database table, along with the view name. But when they go back to edit the view, I will need a sql parser to carve up the saved sql statement, and rebuild the user interface with all the text boxes, pull-downs, click-boxes for selected fields, operators, etc. the way the user saved it.
Is there something out there that does this, without me having to build a whole set of functions, etc. to re-parse the sql statement?
