Multiple Pull Down Menus?

mysq_hell

Hi, me again, Ive made a page on my test system with 2 pull Down menus which pull records from a Database, Ive got it working Pretty lwell but how can i make it so it will select all the records in a category if the default option or all is selcted? let me give you an example..

Menu 1 Shows Make, Menu 2 Shows category

At the moment you choose make from menu 1 and then the category from menu 2 and it shows all records by that Make and in that Category..

For example

If Make = bosch & category = Washing Machine, it will Return all Bosch Washing Machines...

But what if i wanted to list all the Washing machines by all makes? is there a way to add an 'All' to the make pull down menu.. so it doesnt pick just one make but all Makes?

What would the SQL Query Look like?

Obviously i know how to do this as a Separate Query & Form, but would like to Do it all in One Form..

Cheers Paul.

Rodney_H_

Why not use :

<select name="machines">
<option value="all">Select ALL</option> ...

if($_POST['machines'] == "all")
{
// then modify your WHERE clause in the query statement to display all ...
}

else { do what you were doing... }

swatisonee

Hello Paul

I have been struggling with multiple drop downs for ever it seems ! I cannot get the dd to work in a single php script and process the form on which they appear simultaneously. I've tried making 2 scripts for each drop down but then fail to get the form submission done.
Have read quite a few of the tutorials and posts on forums but no luck !

Is it possible for me to see how you have coded this entire dd ?

Thanks !

Just FYI : My 1st drop down has to select a company and the 2nd all the persons in that company. If it can be extended to three then all the cities that these persons are in. Once these are selected then the form has to be processed to print out other data from the table for all records matching these 2 or 3 choices.

Swati

mysq_hell

Can post it tonight, The Select Query looks a lot worse than it is as i have several Related Fields which have to be joined... Im At Work Right now so Dont have access to it til Tonight....

but basically
The Select Query Uses the Forms Variables ($_GET) to Select the records, from the page with the two pull down menus... obviously they are linked to one another via a primary Key and an INT field... ect....

Paul.

mysq_hell

As Requested .. My Multiple Pull Down Menus to filter Results...

<?php require_once('Connections/kenb.php'); ?>
<?php
mysql_select_db($database_kenb, $kenb);
$query_makeRST = "SELECT * FROM make ORDER BY make ASC";
$makeRST = mysql_query($query_makeRST, $kenb) or die(mysql_error());
$row_makeRST = mysql_fetch_assoc($makeRST);
$totalRows_makeRST = mysql_num_rows($makeRST);

$getcat_prodRst = "0";
if (isset($_GET['cat'])) {
  $getcat_prodRst = (get_magic_quotes_gpc()) ? $_GET['cat'] : addslashes($_GET['cat']);
}
$getmake_prodRst = "0";
if (isset($_GET['make'])) {
  $getmake_prodRst = (get_magic_quotes_gpc()) ? $_GET['make'] : addslashes($_GET['make']);
}
mysql_select_db($database_kenb, $kenb);
$query_prodRst = sprintf("SELECT * FROM products, make, category, colour WHERE products.make = make.make_ID AND products.colour = colour.col_ID AND products.category = category.cat_ID AND make.make_ID = %s AND category.cat_ID = %s ORDER BY model ASC", $getmake_prodRst,$getcat_prodRst);
$prodRst = mysql_query($query_prodRst, $kenb) or die(mysql_error());
$row_prodRst = mysql_fetch_assoc($prodRst);
$totalRows_prodRst = mysql_num_rows($prodRst);

mysql_select_db($database_kenb, $kenb);
$query_catRst = "SELECT * FROM category ORDER BY category ASC";
$catRst = mysql_query($query_catRst, $kenb) or die(mysql_error());
$row_catRst = mysql_fetch_assoc($catRst);
$totalRows_catRst = mysql_num_rows($catRst);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Filter Products</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {
	font-size: 36px;
	font-weight: bold;
	color: #990000;
}
-->
</style>
</head>

<body>
<form name="form1" id="form1" method="get" action="getmake.php">
  <select name="make" id="select">
    <option value="0">Make</option>
    <?php
do {  

?>
    <option value="<?php echo $row_makeRST['make_ID']?>"><?php echo $row_makeRST['make']?></option>
    <?php
} while ($row_makeRST = mysql_fetch_assoc($makeRST));
  $rows = mysql_num_rows($makeRST);
  if($rows > 0) {
      mysql_data_seek($makeRST, 0);
	  $row_makeRST = mysql_fetch_assoc($makeRST);
  }
?>
</select> 
  <select name="cat" id="cat">
    <option value="0">Category</option>
    <?php
do {  

?>
    <option value="<?php echo $row_catRst['cat_ID']?>"><?php echo $row_catRst['category']?></option>
    <?php
} while ($row_catRst = mysql_fetch_assoc($catRst));
  $rows = mysql_num_rows($catRst);
  if($rows > 0) {
      mysql_data_seek($catRst, 0);
	  $row_catRst = mysql_fetch_assoc($catRst);
  }
?>
</select>
  <input type="submit" name="Submit" value="Submit" />
</form>
<p>&nbsp; <span class="style2"><?php echo $row_prodRst['make']; ?> <?php echo $row_prodRst['category']; ?></span></p>
<table width="600" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
  <tr bgcolor="#000033">
    <th width="116" scope="col"><div align="left"><span class="style1">Make</span></div></th>
    <th width="120" scope="col"><div align="left"><span class="style1">Model</span></div></th>
    <th width="112" scope="col"><div align="center" class="style1">Colour</div></th>
    <th width="26" scope="col"><div align="center"><span class="style1">Price</span></div></th>
    <th width="210" scope="col"><span class="style1">Qty In Stock </span></th>
    <th width="210" scope="col">&nbsp;</th>
  </tr>
  <?php do { ?>
  <tr bgcolor="#FFFFFF">
    <td><?php echo $row_prodRst['make']; ?></td>
    <td><?php echo $row_prodRst['model']; ?></td>
    <td><div align="center"><?php echo $row_prodRst['colour']; ?></div></td>
    <td><div align="center"><?php echo $row_prodRst['price']; ?></div></td>
    <td><div align="center"><?php echo $row_prodRst['stock_level']; ?>
        <?php if ($totalRows_prodRst > 0) { // Show if recordset not empty ?>
        -Available
        <?php } // Show if recordset not empty ?>
    </div></td>
    <td><a href="basket.php?prod_ID=<?php echo $row_prodRst['prod_ID']; ?>">Bookout</a></td>
  </tr>
  <?php } while ($row_prodRst = mysql_fetch_assoc($prodRst)); ?>
</table>
<p>&nbsp;</p>
</body>
</html>
<?php
mysql_free_result($makeRST);

mysql_free_result($prodRst);

mysql_free_result($catRst);
?>

swatisonee

Thanks !! I'll give it a shot tonight and let you know .