quoted numbers preg_replace

[scottybwoy]

How do I write a regex to strip quotes from an sql query if it contains numbers.

 

i.e.

 

'1234', '2', '23'  becomes 1234, 2, 23.

 

Thanks

[effigy]

$sql = preg_replace("/'(\d+)'/", '$1', $sql);

[scottybwoy]

Thanks,

 

So is the $1 the returned number from the preg_replace?

[.josh]

yes, but it only works within the pattern or within the 2nd argument of preg_replace. You can't turn around do for instance

 

$num = $1;

 

If you want to be able to do something like that, then you need to use preg_match or preg_match_all and it will be assigned to an array specified in the 3rd argument.