Parsing a simple sql string in php

From: Date: Fri, 06 May 2011 09:05:05 +0000
Subject: Parsing a simple sql string in php
Groups: php.general 
Request: Send a blank email to php-general+get-312701@lists.php.net to get a copy of this message
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! Thanks Ash

« previous php.general (#312701) next »