sql/php help

[synchro_irl]

hey guys

im trying to get my search to work from 3 text boxes now, it worked perfectly with 2 text boxes, i.e. location and trade type, as seen fromthe screen shot which shows the webpage view, and the code that is relevant to the search.

 

i have tried to get teh search to work with 3 textboxes, by adding the following:

$search1=$_POST["search1"];
$search2=$_POST["search2"];
$search3=$_POST["search3"];

$result = mysql_query("SELECT * FROM mytable WHERE location LIKE '%$search1%' AND type LIKE '%$search2%' AND name LIKE '%$search3%' ");

 

and heres the screen shot:

 

is this all that is neccessary fo it to work with teh threetext boxes?

 

the name "search3" relates to the name of the new textbox.

 

thanks for the help guys,

steve

 

 

 

[trq]

And your actual problem is?

[synchro_irl]

And your actual problem is?

 

im trying to get the search to work based ont he inputs from 3 textboxes, rather than 2

thats my problem

thanks

steve

[fenway]

Do you mean AND or OR?

[synchro_irl]

Do you mean AND or OR?

 

AND

[fenway]

If you're trying to restrict the results, then yes, what you have will work... just recognize that you shouldn't be including columns that aren't being searched.

[synchro_irl]

If you're trying to restrict the results, then yes, what you have will work... just recognize that you shouldn't be including columns that aren't being searched.

 

it doesnt work though.

i dont know why

it seems perfect to me

any ideas?

 

thanks

 

steve

[fenway]

Define "doesn't work" -- db error, strange results, etc.

[aschk]

If you don't fill in your input boxes do you get any results at all?