Search Problem

[EcLip_e]

Hi,

I'm having a problem with this search feature. For instance: go to http://www.intriguemedia.net/lewismotors/inventory/searchVehicle.php and do a search on "honda". Instead of just bringing up Honda vehicles, it brings up all the vehicles in the database.

Here's my query statement:

$query_rsVehicles = sprintf("SELECT * FROM vehicles WHERE model LIKE '%s%%' OR vehicles.make LIKE '%s%%' AND vehicles.`year` = '%s' ORDER BY ID ASC", $varModel__rsVehicles,$varMake__rsVehicles,$varYear__rsVehicles);

help would greatly be appreciated.

thnx

Dan
intrigue Media // inspire : imagine : intrigue
http://www.intriguemedia.net

[Char]

I'm not too familiar with the sprintf syntax, however have you tried echoing just that string to make sure it looks the way you want it to?

Also, in the query where it says

vehicles.year

should year be in single quotes?

Let me know if this helped,
Charlotte Genevier
Webligo Group
http://www.webligo.com