give me a REGEX please

[Anon]

I want to replace all 'apostrofies with ''double-apostrofies in a SQL query.
I don't want to have to str_replace every element in the SQL query.

for example. INSERT INTO table ('Peter','Be'ngtsson')
...will cause a SQL error.
INSERT INTO table ('Peter','Bengtsson')
...won't cause an error

The Regular Expression I need should work like this:

1) FIND the POSITION of the first '
2) CHECK if there is NO , on EITHER side
3) REPLACE with ''

Or, maybe you have a snipplet ready for this?

[Anon]

Make life easy.

function strip_apos($q) {
$q = str_replace("'","''",$q);
$q = str_replace("(''","('",$q);
$q = str_replace("'')","')",$q);
$q = str_replace("'',","',",$q);
$q = str_replace(",''",",'",$q);

return $q;

}

$query = strip_apos($query);

1) Replace all ' with ''
2) Reverse those that belong to the SQL itself. I.e. next to , commas and )( brackes.