multiple selections scroll down menu

[kareltje]

Hi everybody, Im new here so a little introduction. Iam 30 years, very new to the website developing and php/mysql business and thats why I had to post a question on your forum.

I am developing this website for people to find a particular type of car.

It's something like this (the original website has ofcourse much more choices but to make it easier to read) --> the options:
1. brand of the car: Audi, Opel, BMW
2. color: red, green, black
3. year the car was built: 1990, 1991, 1992

I'm using php and html.

Bwlow is the code + form I'm using which works great (although some say there are a lot of errors and wrong coding, for some reason the code works fine even with error-detection on) . I can make a selection, and when I press search, the results are displayed on results.php using Lightbox (very nice)
My question is: I now have only 1 option I can select. Bij adding size=1 multiple> and [] to for example <select name="brand"> to make it look like <select name="brand[]" size=1 multiple>
I can select multiple options. But when I press the search button I get the message "no selection was made". But I did make a selection. When I remove [] and keep the addition size=1 multiple then I can select multiple options but when I press the search button, the result.php page only dusplays the results of the last selection. For example I select Audi and Opel then the result page only displays Opel pictures. I dont understand what I'm doing wrong. I hope you do.

Thank you very much already!!!!

<?php 
    $brands = array("audi","bmw","opel"); 
    $colors = array("red","groen","black",); 
    if($_SERVER['REQUEST_METHOD'] == 'POST' ) { 
        $where = array(); 
        if (isset($_POST["brand"]) && in_array($_POST["brand"],$brands)) { 
            $where[] = "BRAND='".$_POST["brand"]."'"; 
        } 
        if (isset($_POST["color"]) && in_array($_POST["color"],$colors)) { 
            $where[] = "COLOR='".$_POST["kleur"]."'"; 
        } 
        if (isset($_POST["year"]) && preg_match("/^(19|20)\d\d$/i", $_POST["year"])) { 
            $where[] = "YEAR='".$_POST["year"]."'"; 
        } 
        if (count($where)==0) { 
            echo "no selection was made."; 
        } else { 
            $query = "select ID, BRAND, COLOR, YEAR from catalog_table WHERE ".implode(" AND ",$where); 
            if ($result = mysql_query($query)) { 
                if (mysql_num_rows($result)<>0) { 
                    while ( $row = mysql_fetch_assoc ( $result ) ) { 
                        echo $row["BRAND"]." - ".$row["COLOR"]." - ".$row["YEAR"]."<br />"; 
                        $informationquery = "select INFORMATION from information where Catalog_ID=".$row["ID"]; 
                        if ($informationresult = mysql_query($informationquery)) { 
                            if (mysql_num_rows($informationresult)<>0) { 
                                while ( $informationrow = mysql_fetch_assoc ( $informationresult ) ) { 
                                    echo $informationrow["INFORMATION"]."<br />"; 
                                } 
                            } else { 
                                echo "no information availible<br />"; 
                            } 
                        } 
                        $photoquery = "select PHOTO from foto where Catalog_ID=".$row["ID"]; 
                        if ($photoresult = mysql_query($photoquery)) { 
                            if (mysql_num_rows($photoresult)<>0) { 
                                while ( $photorow = mysql_fetch_assoc ( $photoresult ) ) { 
                                    echo '<a title="' . $row['PHOTO'] . '" href"images/big/' . $row['PHOTObig'] . "' rel="lightbox"><img src="images/thumbs/' . $photorow['PHOTOthumb']."' alt='".$row["BRAND"]." - ".$row["COLOR"]." - ".$row["YEAR"]."' /><br />"; 
                                } 
                            } else { 
                                echo "<img src='nophoto.jpg' alt='no photo' /><br />"; 
                            } 
                        } 
                    } 
                } else { 
                    echo "no cars matched your selection."; 
                } 
            } 
        } 
} 

?> 
<hr /> 
<form method="post" action="result.php"> 
    <select name="brand"> 
        <option selected="selected">Brand</option> 
        <option><?php echo implode("</option><option>",$brands); ?></option> 
    </select> 
    <select name="color"> 
        <option selected="selected">Color</option> 
        <option><?php echo implode("</option><option>",$colors); ?></option> 
    </select> 
    <select name="year"> 
        <option selected="selected">Year</option> 
        <option>1990</option> 
        <option>1991</option> 
        <option>1992</option> 
    </select> 
    <input type="submit" value="search" /> 
</form>

[kareltje]

Hi all,
I changed my code (see below). I can make multiple selections but the result page does not show any results. Not even the error messages like "no selection was made". Does anyone know the reason and maybe a solution?

<?php
    $brands = array("audi","bmw","opel");
    $colors = array("red","groen","black",);
    if($_SERVER['REQUEST_METHOD'] == 'POST' ) {
        $where = array();
      if (isset($_POST["brand"]))
{
  foreach($_POST["brand"] as $brand)
  {
    if (!in_array($brand, $brands))
    {
      $where[] = "BRAND=$brands";
    }
  }
}
       if (isset($_POST["color"]))
{
  foreach($_POST["color"] as $color)
  {
    if (!in_array($color, $colors))
    {
      $where[] = "COLOR=$color";
    }
  }
}        

        if (count($where)==0) {
            echo "no selection was made.";
        } else {
            $query = "select ID, BRAND, COLOR, YEAR from catalog_table WHERE ".implode(" AND ",$where);
            if ($result = mysql_query($query)) { 
                if (mysql_num_rows($result)<>0) { 
                    while ( $row = mysql_fetch_assoc ( $result ) ) { 
                        echo $row["BRAND"]." - ".$row["COLOR"]."<br />"; 
                        $informationquery = "select INFORMATION from information where Catalog_ID=".$row["ID"]; 
                        if ($informationresult = mysql_query($informationquery)) { 
                            if (mysql_num_rows($informationresult)<>0) { 
                                while ( $informationrow = mysql_fetch_assoc ( $informationresult ) ) { 
                                    echo $informationrow["INFORMATION"]."<br />"; 
                                } 
                            } else { 
                                echo "no information availible<br />"; 
                            } 
                        } 
                        $photoquery = "select PHOTO from foto where Catalog_ID=".$row["ID"]; 
                        if ($photoresult = mysql_query($photoquery)) { 
                            if (mysql_num_rows($photoresult)<>0) { 
                                while ( $photorow = mysql_fetch_assoc ( $photoresult ) ) { 
                                    echo '<a title="' . $row['PHOTO'] . '" href"images/big/' . $row['PHOTObig'] . "' rel="lightbox"><img src="images/thumbs/' . $photorow['PHOTOthumb']."' alt='".$row["BRAND"]." - ".$row["COLOR"]." - ".$row["YEAR"]."' /><br />"; 
                                } 
                            } else { 
                                echo "<img src='nophoto.jpg' alt='no photo' /><br />"; 
                            } 
                        } 
                    } 
                } else { 
                    echo "no cars matched your selection."; 
                } 
            } 
        }
}

?>
<hr />
<form method="post" action="result.php">
    <select name="brand[]" size="3" multiple>
        <option selected="selected">Brand</option>
        <option><?php echo implode("</option><option>",$brands); ?></option>
    </select>
    <select name="color[]" size="3" multiple>
        <option selected="selected">Color</option>
        <option><?php echo implode("</option><option>",$colors); ?></option>
    </select>
    <input type="submit" value="search" />
</form>

[kareltje]

Hi all, I changed my code (see below). I changed

 if (isset($_POST["brand"]) && in_array($_POST["brand"],$brands)) {
            $where[] = "BRAND='".$_POST["brand"]."'";
        }
        if (isset($_POST["color"]) && in_array($_POST["color"],$colors)) {
            $where[] = "COLOR='".$_POST["color"]."'";
        }

into

  if (isset($_POST["brand"]))
{
  foreach($_POST["brand"] as $brand)
  {
    if (!in_array($brand, $brands))
    {
      $where[] = "BRAND=$brands";
    }
  }
}

<?php
    $brands = array("audi","bmw","opel");
    $colors = array("red","groen","black",);
    if($_SERVER['REQUEST_METHOD'] == 'POST' ) {
        $where = array();
      if (isset($_POST["brand"]))
{
  foreach($_POST["brand"] as $brand)
  {
    if (!in_array($brand, $brands))
    {
      $where[] = "BRAND=$brands";
    }
  }
}
       if (isset($_POST["color"]))
{
  foreach($_POST["color"] as $color)
  {
    if (!in_array($color, $colors))
    {
      $where[] = "COLOR=$color";
    }
  }
}        

        if (count($where)==0) {
            echo "no selection was made.";
        } else {
            $query = "select ID, BRAND, COLOR, YEAR from catalog_table WHERE ".implode(" AND ",$where);
            if ($result = mysql_query($query)) { 
                if (mysql_num_rows($result)<>0) { 
                    while ( $row = mysql_fetch_assoc ( $result ) ) { 
                        echo $row["BRAND"]." - ".$row["COLOR"]."<br />"; 
                        $informationquery = "select INFORMATION from information where Catalog_ID=".$row["ID"]; 
                        if ($informationresult = mysql_query($informationquery)) { 
                            if (mysql_num_rows($informationresult)<>0) { 
                                while ( $informationrow = mysql_fetch_assoc ( $informationresult ) ) { 
                                    echo $informationrow["INFORMATION"]."<br />"; 
                                } 
                            } else { 
                                echo "no information availible<br />"; 
                            } 
                        } 
                        $photoquery = "select PHOTO from foto where Catalog_ID=".$row["ID"]; 
                        if ($photoresult = mysql_query($photoquery)) { 
                            if (mysql_num_rows($photoresult)<>0) { 
                                while ( $photorow = mysql_fetch_assoc ( $photoresult ) ) { 
                                    echo '<a title="' . $row['PHOTO'] . '" href"images/big/' . $row['PHOTObig'] . "' rel="lightbox"><img src="images/thumbs/' . $photorow['PHOTOthumb']."' alt='".$row["BRAND"]." - ".$row["COLOR"]." - ".$row["YEAR"]."' /><br />"; 
                                } 
                            } else { 
                                echo "<img src='nophoto.jpg' alt='no photo' /><br />"; 
                            } 
                        } 
                    } 
                } else { 
                    echo "no cars matched your selection."; 
                } 
            } 
        }
}

?>
<hr />
<form method="post" action="result.php">
    <select name="brand[]" size="3" multiple>
        <option selected="selected">Brand</option>
        <option><?php echo implode("</option><option>",$brands); ?></option>
    </select>
    <select name="color[]" size="3" multiple>
        <option selected="selected">Color</option>
        <option><?php echo implode("</option><option>",$colors); ?></option>
    </select>
    <input type="submit" value="search" />
</form>

The problem is that I don't get any result. Not even the error massages like "no selection was made". Does anyone knows why, or a solution to this problem?

[rincewind456]

If you're not getting any results then the first thing to do is to see if the query is valid, echo out the Sql query and run it from phpMyadmin or the commandline to see if provides the answers you expect.

[mark_kccs]

Hi kareltje

I think you may have a few syntax errors in you code.

you have:

while ( $photorow = mysql_fetch_assoc ( $photoresult ) ) { 
echo '<a title="' . $row['PHOTO'] . '" href"images/big/' . $row['PHOTObig'] . "' rel="lightbox"><img src="images/thumbs/' . $photorow['PHOTOthumb']."' alt='".$row["BRAND"]." - ".$row["COLOR"]." - ".$row["YEAR"]."' /><br />"; 
}

but i think it should be:

while ( $photorow = mysql_fetch_assoc ( $photoresult ) ) { 
echo '<a title="' . $row['PHOTO'] . '" href="images/big/' . $row['PHOTObig'] . '" rel="lightbox"><img src="images/thumbs/' . $photorow['PHOTOthumb'].'" alt="'.$row["BRAND"].' - '.$row["COLOR"].' - '.$row["YEAR"].'" /><br />'; 
}

You are mixing the single and double quotes and you missed the '=' after the href.

You should have some error messages or warnings if i'm correct. If not look at the error settings in your php.ini.

[mark_kccs]

Hi again

Just noticed this:

if (isset($_POST["color"]) && in_array($_POST["color"],$colors)) { 
      $where[] = "COLOR='".$_POST["kleur"]."'"; 
}

The name for the menu is 'color' so it should be:

if (isset($_POST["color"]) && in_array($_POST["color"],$colors)) { 
      $where[] = "COLOR='".$_POST["color'"]."'"; 
}