Re: str_replace question

I can't think of an instance where a query would have the phrase "WHERE AND". Perhaps if you post the contents of the $additionalsql variable, we can tell you why it's not working. You may actually be looking to use an array for your search words in str_replace(), or perhaps grep. On Jan 5, 2005, at 8:05 PM, Chris Payne wrote:

Hi there everyone, I’m having a weird problem and I’m not sure why, if I try to replace WHERE AND with just WHERE it won’t do it, but if I try to replace WHERE or AND by themselves it WILL do it, but I cannot replace BOTH of them from a single string, is something wrong below? $additionalsql = str_replace("WHERE AND", "WHERE", $additionalsql); Basically I’m trying to replace WHERE AND with just WHERE as I’m building a very complex SQL query and it’s a difficult one, and I have a solution that works perfectly but I need this to work in order to do it. I would appreciate any help on this, as it’s very important. Chris -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.6.7 - Release Date: 12/30/2004 -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577