Your Open Source
Free YourOpenSource Softwares Online Resources and Softwares Downloads with Demo
Related Links
PHP
Search data using more than one search fields
Search data using more than one search fields :-
I have a php search page which is having more than one search felds. This is my querySELECT * FROM vehicles WHERE VehicleType='$type' AND VehicleMake='$make' AND VehicleModel='$model' AND Year= '$year' AND Price BETWEEN '$minPrice' AND '$maxPrice'
This will get results only if all fields match. But I want to get results if only one field match. How can I do that?
ex: If user enter only vehicle make and price I want to display data by searching db only the entered fields.
56
Oct 06 09 07:12:21
Tech
Rating : 









|
|||||
Digg
Yahoo
delicious