Using LIKE statement but excluding rows

[melting_dog]

Hi all,

 

I have a site that displays a product, then shows similar products based off the name of the first (like a 'You might also like...' list). However the original product keeps appearing in this similar product list. I need a way to exclude that product.

 

You can see this here:

 

http://adamsherman.com.au/postureperfection/product-page/?prodid=3

 

Notice how the Reno Stool also appears in the suggested items list.

 

Can anyone help me out? Heres the SQL:

 

$sql = "SELECT * FROM product WHERE " . implode(' OR ', $searchTerms) . " AND product_id != '$prodid' LIMIT 3";

 

The .implode() just splits up the name of the item whilst $prodid is the items unique identifier. I have also tried NOT LIKE, <> and != $productname as well.

 

Any help would be much appreciated. Thanks!

[Muddy_Funster]

could you do a print_r($sql) and post up what you get from it please.

[melting_dog]

Hi Muddy,

 

This is what I get:

 

SELECT * FROM product WHERE name LIKE '%Reno%' OR name LIKE '%Stool%' AND product_id != '3' LIMIT 3

[Muddy_Funster]

I think it's an order problem, lets fling in some brackets and see what happens:

$sql = "SELECT * FROM product WHERE ((" . implode(' OR ', $searchTerms) . ") AND (product_id != '$prodid' LIMIT 3))";

[melting_dog]

Hi Muddy,

 

Thanks - I was able to do it by modifying your statement a bit:

 

$sql = "SELECT * FROM product WHERE (" . implode(' OR ', $searchTerms) . ") AND product_id != '$prodid' LIMIT 3";

 

Works like a charm!

 

Thanks!

[Muddy_Funster]

Glad you got it working, I see the problem in the code I gave you was that I included the LIMIT statment inside the brackets aswell >_<