Populate one list box from the selection of another list box

shure2

Hi,

I have a list box that reads category names values from the category table. I want to select a category name and populate the product list box with the names of products in the category.

I have the code to populate the category listbox and the sql to populate the product listbox, but i'm not sure how to put them together (I guess calling a seperate php file and then passing the values back somehow?)

<p>Select the product category:<br />
                        <select name="prodcategory" onchange="javascript: form.action='reportmanual_getcategoryproducts.php';">

                        <?php
                        $selectProductCatQuery = "SELECT * FROM category where userid = '".$_SESSION['userid']."' ORDER BY catname";

                        $selectProductCatResult = mysql_query($selectProductCatQuery) or die(mysql_error());

                        while($row1ProductCat=mysql_fetch_array($selectProductCatResult))
                        {
                            echo '<option value="'.$row1ProductCat['catname'].'">'.$row1ProductCat['catname'].'</option>'; 
                        }
                        ?>
                    </select>

$query = "SELECT * FROM product where userid = '".$_SESSION['userid']."' and categoryname = '".$_GET['prodcategory']."' ORDER BY catname";
                            $result = mysql_query($query) or die(mysql_error());

djjjozsi

echo the $query and you will see the $_GET['prodcategory'] hasn't set.

If you have a form with POST method, you get the posted values by $_POST["prodcategory"].

You can easily design a double listbox Here

One little change should do here, is to change the queries and add userid fields into the tables.

shure2

djjjozsi;10948702 wrote:
echo the $query and you will see the $_GET['prodcategory'] hasn't set.

If you have a form with POST method, you get the posted values by $_POST["prodcategory"].

You can easily design a double listbox Here

One little change should do here, is to change the queries and add userid fields into the tables.

Hi, thanks for your reply,

I have added userid to the tables and have fixed the code so that when I select a category and click a button I am taken to another page where there is a listbox with the products from that category, however I would like the category and product list boxes to be on the same page, I am more than happy to have the page refresh when the category is selected so that I don't have to use javascript.

CODE FOR PRODUCT LISTBOX:

<?php
    require "session_logincheck.php";
    require "connect.php";


    ?>

    <?php
    $query = "select * from product where prodcategory = '".$_GET['prodcategory']."' and userid = '".$_SESSION['userid']."'";
    $result = @mysql_query($query, $connection)or die ("Unable to perform query<br>$query");

    ?>
    <select name="dddd">
        <?php
    while($row=mysql_fetch_array($result))
        {
            echo '<option value="'.$row['prodid'].'">'.$row['prodname'].'</option>';
        }    
    ?>
    </select>

djjjozsi

you should set the first form's action to the current page,
and add an IF condition for the $_GET["prodcategory"] variable.

if(isset($_GET["prodcategory"]))
{
//second query and listbox goes here...
}