Skip to main content
A
apirie
Participant
July 11, 2009
Question

Search function within dreamweaver / SQL

  • July 11, 2009
  • 1 reply
  • 770 views

Hi, I've been a couple of simple shopping sites through Dreamweaver.

One feature all products - www.drinkemporium.com - the other just a selection of products (one kind) - www.vodkaemporium.com.

At the moment, the two sites use separate databases, with the vodka stuff duplicated in its own db. I'd like to combine both sites to use a single db.

However, I've hit a problem. Both sites use a simple search engine. How do I set the vodka site to only search the vodka products in my db? Product types are set by an entered value in one of the db columns.

My SQL code looks like this:

SELECT *
FROM drinkemporium
WHERE Name LIKE CONCAT('%', colname, '%') OR Description LIKE CONCAT('%', colname2, '%')

I need to add another criteria telling it to only search results where Type = X and not Y or Z.

Can anyone help?

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
July 11, 2009

>I need to add another criteria telling it to only search results where Type = X and not Y or Z.

Your where clause needs to look something like this

WHERE (Name LIKE CONCAT('%', colname, '%') OR Description LIKE CONCAT('%', colname2, '%')) AND Type= 'vodka'

Make sure you wrapp the OR'ed expressions with parens so they are evaluated together, and the AND'd expression is evaluated separately.

A
apirieAuthor
Participant
July 12, 2009

Brilliant thanks!

I had to put the Type query at the start... but it now works.

SELECT *
FROM drinkemporium
WHERE Type=vodka AND (Name LIKE CONCAT('%', colname, '%') OR Description LIKE CONCAT('%', colname2, '%'))

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices