Search from Checkbox

[techker]

Hey guys im going nuts here..i have a car dealership script to do for my budy and i want to do a multiple search for by make..

 

so i got a litle test script im doing to figure out the results..

 

 

 
$search_string = "'" . implode( "','", $search ) . "'" ;$q3 = "select * from `cars` where Make  in ('$search_string') ORDER BY `Make` ASC LIMIT 0 , 30 ";$result = mysql_query($q3);                      while($info = mysql_fetch_array($result)){ echo $info['Make'];  }echo "select * from `cars` where Make  in ({$search_string} ) was selected!\n"; 

 

So the odd think is i cant get an echo results of it..

 

so i echo a txt base line to see what the query is.

 

i get

(selected Acura and BMW)

 

select * from `cars` where Make in ('Acura','BMW' ) was selected!

 

So if i paste in phpmyadmin

 

select * from `cars` where Make in ('Acura','BMW' )

 

works perfect..

 

so why does it not echo?(i just put Make to test for now)

 

thx

[Barand]

try

in ($search_string)

without the single quotes ($searchstring already has quotes)

[techker]

im must of been tired..lol

 

seems to work..thx

[techker]

would you now how to search in database like price under 5000 over 5000?

 

but the issue is is that the column Retail_Price hase the numbers like 5,000 it has that (,) so when i try <= 5,000 i get a mysql error..

[DavidAM]

Retail_Price should be a NUMERIC column (not VARCHAR), so it will not have the comma in it. Then you can use Retail_Price <= 5000. Using a string-type field for numeric data will make it virtually impossible to compare: i.e. 120 < 30 when compared as a string.