A neat little trick would be to create the initial part of the statement with a predefined where clause based on some record state. For instance, we use a record_deleted field, since we don't delete data. He could start his statement by automatically looking for it
select * from tablename where record_deleted = 'No'
then any additional clauses that get added all require the AND keyword. No more problem
bastien
From: Brent Baisley <[EMAIL PROTECTED]> To: "Chris Payne" <[EMAIL PROTECTED]> CC: <php-db@lists.php.net> Subject: Re: [PHP-DB] str_replace question Date: Thu, 6 Jan 2005 09:20:47 -0500
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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
