On Fri, May 6, 2011 at 10:05 AM, Ashley Sheridan <a...@ashleysheridan.co.uk> wrote: > Hiya, has anyone had any experience with parsing a string of sql to break it > down into its component parts? At the moment I'm using several regex's to > parse a string, which works, but I'm sure there's a more elegant solution. > > The general idea is to produce a nice looking page giving details of updated > fields and values. > > I'm only concerned with update statements really, and the queries are very > simple, operating on one table at a time, with no sub queries or selects. > > Thanks in advance if anyone is able to suggest anything!
I'd suggest at least taking a look at pear's sql parser package - using it might save you some headaches ;) http://pear.php.net/package/SQL_Parser > Thanks > Ash > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- http://blogs.linux.ie/kenguest/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php