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
tried to explain that to him already, either he ignored it or its too complex - can't say because he never responded.
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.
-- 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php