chris, you'll need to do a little PHP manipulation, perhaps (pseudo)
if "-<word." (regular expression?)
for each -<word>
SQL .= " NOT LIKE '%<word>% AND'"
endforeach
endif
for each <other word>
SQL .= " LIKE '%<word>%' AND"
endforeach
strip trailing "AND"
clean up SQL as required
query db
-----------------
ok, obviously that's very rough, but i think something like that will work
:)
HTH
Beau
// -----Original Message-----
// From: Chris Payne [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 30 May 2002 12:22 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] mysql exclusion in php
//
//
// Hi there everyone,
//
// How can I do a search which excludes certain words if they
// put a - in the search string? I can do a search easily, but
// if they put a - infront of a word in the string, how can I
// then get MySQL to search all entries EXCEPT where the word
// with a - next to it appears?
//
// Thanks for everything.
//
// Chris
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
