Hi,

I'm having a problem with this search feature. For instance: go to 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:

SELECT *
FROM vehicles
WHERE model LIKE 'varModel%' OR vehicles.make LIKE 'varMake%' AND vehicles.`year` = 'varYear'
ORDER BY ID ASC

some help would greatly be appreciated.

Dan
www.intriguemedia.net

<font face='Tahoma'>
SELECT *
FROM vehicles
WHERE model LIKE '<b>%varModel%</b>' OR vehicles.make LIKE '<b>%varMake%</b>' AND vehicles.`year` = 'varYear'
ORDER BY ID ASC

Goog luck,
jogi
</font id='Tahoma'>

what did you do different?!

------------------------
Julio

PHP | MySQL | DWMX | ColdFusion

ICQ: 19735247

Dear Dan,

WHERE (model LIKE 'varModel%' OR vehicles.make LIKE 'varMake%') AND vehicles.`year` = 'varYear'

Note the addition of the parenthesis.

Regards,
Brent