From: Jonathan David Edwin Wright [EMAIL PROTECTED]
Which turns '+php -perl' into:
SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%'
The problem I get is that the query doesn't seam to work. One of the
books in the table is 'Professional PHP Programming', but, while
Shouldn't the NOT be right before the LIKE:
SELECT * FROM books WHERE title LIKE '%php%' AND title NOT LIKE '%perl%'
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
-Original Message-
From: Jonathan David
Your query reads: SELECT * FROM books WHERE title LIKE '%php%' AND NOT
title LIKE '%perl%' whereas it has to be ... AND title NOT LIKE '%perl%';
I think you need to make some changes in your PHP code for the in the case
block for - .
Gurhan
-Original Message-
From: Jonathan David
At 12:34 -0400 4/25/02, denonymous wrote:
From: Jonathan David Edwin Wright [EMAIL PROTECTED]
Which turns '+php -perl' into:
SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%'
The problem I get is that the query doesn't seam to work. One of the
books in the table