[RESOLVED] preg_replace

[zzz]

I have a stored long string

$str = '77000,77001,77002,77003,77004,77005,77006,77007,77008,77009,77010';

I need to turn it into a part of a query string to look like this:

77000 OR zipcode = 77001 OR zipcode = 77002 OR zipcode = 77003 OR zipcode = 77004 OR zipcode = 77005 OR zipcode = 77006 OR zipcode = 77007 OR zipcode = 77008 OR zipcode = 77009 OR zipcode = 77010

I've tried

$newStr = preg_replace(',', ' OR zipcode = ', $str);

but I can't seem to get any results... What am I missing?

[laserlight]

I suggest that you change to use IN (77000, 77001) instead:

$str = 'IN (' . implode(',', $str) . ')';

[zzz]

Actually I need to keep the 77006 OR zipcode = 77007 OR zipcode = 77008 format. Because this is an alternate solution to existing code. It works fine, i just need to tweak it this way for now. IN (...) solution will require code rewrite more then I have time for at the moment...

[laserlight]

Actually I need to keep the 77006 OR zipcode = 77007 OR zipcode = 77008 format. Because this is an alternate solution to existing code. It works fine, i just need to tweak it this way for now. IN (...) solution will require code rewrite more then I have time for at the moment...

hmm... but whenever you have:

zipcode = 77000 OR zipcode = 77001 OR zipcode = 77002 OR zipcode = 77003

you can directly replace that with:

zipcode IN (77000, 77001, 77002, 77003)

The version with IN is also likely to be better optimised.

[zzz]

Oh, I see. You're right. I won't have to make any further changes. Great. Lemme give it a whirl. 😉