search data using more than one search fields

ghjk

I have a php search page which is having more than one search felds. This is my query

Expand|Select|Wrap|Line Numbers

 
SELECT * 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.

ssnaik84

build a dynamic query..

Expand|Select|Wrap|Line Numbers

 $sql = "SELECT * FROM vehicles WHERE ";

if($type != '') { $sql = $sql + " VehicleType='$type' AND " }

if($make != '') { $sql = $sql + " VehicleMake='$make ' AND " }

...

.. so on

well, i'm not good at PHP :)

kkshansid

Quote:

Originally Posted by ssnaik84

build a dynamic query..

we have to make any one field necessary for this.howz it possible if users doesnt enter any field than all display

ghjk

Still I'm confusing. Because of "AND" operator It didn't get any results.

kkshansid

Quote:

Originally Posted by ghjk

Still I'm confusing. Because of "AND" operator It didn't get any results.

Expand|Select|Wrap|Line Numbers

 
   1. $sql = "SELECT * FROM vehicles WHERE ";

   2. if($type != '') {  $sql = $sql + " VehicleType='$type' " }

   3. if($make != '') {$sql = $sql + " AND  VehicleMake='$make '  " }

   4. if($make1 != '') {$sql = $sql + " AND  VehicleMake1='$make1 '  " }

   5. ...

   6. .. so on

make any one of the field neccessry to enter and make that field variable in the second line.while other field variables in remaining lines

ghjk

When I check this code It gives an error message.

Expand|Select|Wrap|Line Numbers

 
$sql = "SELECT * FROM vehicles WHERE ";

if($type != '') {$sql = $sql+ "vehicle_type = 'Car'"}

if($Make != '') {$sql = $sql + " AND  VehicleMake='Zusuki'" }

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if($type != '') {$sql = $sql+ "vehicle_type = 'Car'"}
if($Make != '') {$sql = $' at line 1

kkshansid

Expand|Select|Wrap|Line Numbers

 $query = "SELECT * FROM table where f1 = '$f1'";/*u have to make f1 necessary to fill*/

if(is_string($f2) && $f2<>"")

$query .= " and f2 = '$f2'";

if(is_string($f3) && $f3<>"")

$query .= " and f3 = '$f3'";

.

.

.

So on;

try this it will work

ghjk

Thanx kkshansid. It's working.

search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

re: search data using more than one search fields

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about