Jump to content


Photo

Multiple search field Help


  • Please log in to reply
3 replies to this topic

#1 luisantonio

luisantonio
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 16 October 2005 - 09:41 PM

Hi,

I need a little help to make a multiple search with dreamweaver using PHP. My text box name in the search page is products since I had it working only searching the product name, but now I want to be able to search by product name and iten code(code) using only one textbox for the search.

Below is the sql I am trying in dreamweaver for the multiple search function.

SELECT *
FROM products
WHERE product = 'colname' OR code = 'colname2'
ORDER BY product ASC

Name = colname Default value= 1 Run time value = $HTTP_POST_VARS['product']
Name = colname2 Default value= 1 Run time value = $HTTP_POST_VARS['code']

Using OR it searches for product name(product) but using AND does not bring any results.

Thanks.

#2 rsnell

rsnell
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 16 October 2005 - 11:10 PM

Why would CODE = 'colname2' , aren't you expecting a number? The AND is picky and require an exact match. The OR will take either condition of PRODUCT or CODE matching.

#3 luisantonio

luisantonio
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 17 October 2005 - 12:50 AM

Why would CODE = 'colname2' , aren't you expecting a number? The AND is picky and require an exact match. The OR will take either condition of PRODUCT or CODE matching.

View Post



Dreamweaver asign the variable name as colname, don't know why, this was asign by default by dreamweaver. I asign colname2 for the code field fron the table, thinking it might work.



#4 ThE_eNd

ThE_eNd
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 16 November 2005 - 10:43 PM

And it should work.

you can change colname and colname2 to whatever you want.

And in the SQL Statement window you should have:

SELECT * FROM products
WHERE product = 'whatever' OR code = 'whateverelse'
ORDER BY product ASC

Name = whatever Default value= 1 Run time value = $HTTP_POST_VARS['product']
Name = whateverelse Default value= 1 Run time value = $HTTP_POST_VARS['code']





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users