luisantonio

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.

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.