Hi,

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

sorry, the URL is www.intriguemedia.net/lewismotors/inventory/searchVehicle.php

At a guess, the Vehicle etc. selected/searched for isn't being picked up and stored in the variables varMake varModel etc.

Check to see if this is the case by changing the default values of the variables.

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only):
www.tdsf.co.uk/tdsfdemo/Shop.htm


Multiple Parameter UD4 / Access 2000 Search Tutorial:
www.tdsf.co.uk/tdsfdemo/

Dear Dan,
Owen is probably correct - also, check my response in the PHP forum to make your query more concise.

Regards,
Brent

PS - don't post the same question to different forums.