Re: [PHP] Extract column names from a (my)SQL query

I haven't finished reading it yet - but this looks great - Thank you so much! On Thu, Aug 20, 2009 at 4:36 PM, kranthi wrote: > this might be some help... > > http://stackoverflow.com/questions/283087/php-mysql-sql-parser-insert-and-update > -- Use ROT26 for best security

Re: [PHP] Extract column names from a (my)SQL query

this might be some help... http://stackoverflow.com/questions/283087/php-mysql-sql-parser-insert-and-update -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Extract column names from a (my)SQL query

Lets assume I have the following string: "SELECT field1, field2, field3 FROM tablename WHERE field1 = 'something' " Is there any way to get "field1, field2, field3"? assuming it might also have join, left join - things like that. I can easily do it with preg_match, but I have to make sure its "fo