if statement and drop menu

[sabo86]

if($_POST['searchtype']="Accessories")

  $field='Accessories';

  elseif ($_POST['searchtype']="Seatings")

  $field='Seatings';

  elseif ($_POST['searchtype']="Local Office Furniture")

  $field='Local Office Furniture';

    elseif ($_POST['searchtype']="European Office Furniture")

  $field='European Office Furniture';

  elseif ($_POST['searchtype']="School and University Furniture")

  $field='School and University Furniture';

 

$query = "select * FROM items where Category = '$field'";

 

Just wondering why $field is always taking the string 'Accessories'?

knowing that searchtype is the drop menu form..??

[kratsg]

Two things:

 

One: when posting code, put them in between [*code][*/code] tags.

 

Two: fix your conditionals, you're literally setting the $_POST['searchtype'] variables to those values:

 

if($_POST['searchtype']="Accessories")

 

to

 

if($_POST['searchtype']=="Accessories")

 

instead.

[sabo86]

Thanks a lot