Jump to content

Archived

This topic is now archived and is closed to further replies.

luisantonio

Multiple search field Help

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

307208[/snapback]

 

 

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.

 

 

Share this post


Link to post
Share on other sites

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']

 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.