Codeman0013

I want to use

unset($_POST['productCat_id']);

to clear out my url if the user selects a new industry_id . Here is my code maybe you can help me understand where it goes...

<form name="distributers" />			  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td width="15%">Industry:</td>				<td width="85%">				<select name="industry_id" id="industry" onchange="document.distributers.submit();">								  <option value="">Select an Industry...</option>				  <?php do { ?>				 <?php   					 print "<option value=\"{$row_rs_industry['industry_id']}\"" .					(isset($_GET['industry_id']) && $_GET['industry_id'] == $row_rs_industry['industry_id'] ? " selected>" : ">") .    					 "{$row_rs_industry['industry_name']}</option>\n";?>						 						  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?>				</select> </td></tr>				 <tr><td>Product category:</td><td>				 				 <?php if ($_GET['industry_id'] == null || $_GET['industry_id'] == "")  { ?>				 				 <select name="productCat_id" id="productcat" onchange="document.distributers.submit();" disabled>;				 <?php } else { 					mysql_select_db($database_conn_dj, $conn_dj);					$query_rs_productcategory = "SELECT productCat_id, productCat_name, industry_id FROM tbl_productcat WHERE industry_id = '$_GET[industry_id]' ORDER BY productCat_name";					$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());					$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);					$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);				 ?>			 			<select name="productCat_id" id="productcat" onchange="document.distributers.submit();" >				  <option value="">Select a product category...</option>				<?php do {   					 print "<option value=\"{$row_rs_productcategory['productCat_id']}\"" .					(isset($_GET['productCat_id']) && $_GET['productCat_id'] == $row_rs_productcategory['productCat_id'] ? " selected>" : ">") .    					 "{$row_rs_productcategory['productCat_name']}</option>\n";				 } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?>				</select>		 		<?php } ?></td>								<tr><td>Product:</td><td>									 <?php if ($_GET['productCat_id'] == null || $_GET['productCat_id'] == "" || ($_GET['industry_id'] == null || $_GET['industry_id'] == "")) { ?>				 <select name="products_id" id="products" onchange="document.distributers.submit();" disabled>;				 <?php } else { 						mysql_select_db($database_conn_dj, $conn_dj);					$query_rs_product = "SELECT products_id, products_name, productCat_id FROM tbl_products WHERE productCat_id = '$_GET[productCat_id]' ORDER BY products_name";					$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());					$row_rs_product = mysql_fetch_assoc($rs_product);					$totalRows_rs_product = mysql_num_rows($rs_product);					?>		 			<select name="products_id" id="products" onchange="document.distributers.submit();" >				  <option value="">Select a product...</option>					<?php do {	   					 print "<option value=\"{$row_rs_product['products_id']}\"" .						(isset($_GET['products_id']) && $_GET['products_id'] == $row_rs_product['products_id'] ? " selected>" : ">") . 	   					 "{$row_rs_product['products_name']}</option>\n";					 } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>					</select>				<?php } ?> 									</td></tr>				<tr><td> </td><td><input type="submit" value="Find" name="find"></td></tr>		  </table>			</form>

Hey right now my dropdown only submits one value but i also want it to submit a blank value for the next one as well which is the productCat_id drop down...

<select name="industry_id" id="center" onchange="document.distributers.value='industry_id';document.distributers.submit();"

how would i change that line to make that work?

Hey maybe someone can help me with this i have tried all i know about it. I have 3 dropdowns all of which work correctly accept for one problem. When the user refreshes the first one and changes their choice it repopulates the second one like it should but the 3rd one isnt reset as well. How do i set the first one aka industry ot send a blank value to the url for both of the 2 corresponding menu's after it??? here is my code..

<?php require_once('Connections/conn_dj.php'); ?><?phpmysql_select_db($database_conn_dj, $conn_dj);$query_rs_industry = "SELECT industry_id, industry_name FROM tbl_industry ORDER BY industry_name ASC";$rs_industry = mysql_query($query_rs_industry, $conn_dj) or die(mysql_error());$row_rs_industry = mysql_fetch_assoc($rs_industry);$totalRows_rs_industry = mysql_num_rows($rs_industry);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_outsidena = "SELECT * FROM intl_countries ORDER BY intl_countries.name";$rs_outsidena = mysql_query($query_rs_outsidena, $conn_dj) or die(mysql_error());$row_rs_outsidena = mysql_fetch_assoc($rs_outsidena);$totalRows_rs_outsidena = mysql_num_rows($rs_outsidena);?><!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>DICKEY-john Corporation | Distributors</title><link href="_lib/sub.css" rel="stylesheet" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="keywords" content="Distributor, Sales, Purchase, U.S., International" /><meta name="description" content="Enter your zip or postal code to find the DICKEY-john distributor nearest you." /></head><body> <div id="black"> </div><div id="siteContainer">	<?php include("_inc/topNav.inc"); ?>	<div id="headerContainer">Distributors</div>	<div class="divContainer"><div class="horizDiv"></div><img src="/_img/divEnd.png" alt="div" height="16" width="4" align="right" /></div>	<div id="contentContainer">		<div id="fullContainer">			<div id="stretchCrumbs">				<a href="/index.php">Home</a>				» <a class="high" href="/distributors/">Distributors</a>			</div>			<h1>Distributors</h1>			<p>Search for DICKEY-john distributers by specifying any combination of the<br />			following classifications: industry, product category, product, and state.</p>			<br />						<br />												<h2>North America</h2>			<form name="distributers">			  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td width="15%">Industry:</td>				<td width="85%">				<select name="industry_id" id="industry" onchange="document.distributers.value='industry';document.distributers.submit();" >				  <option value="">Select an Industry...</option>				  <?php do { ?>				 <?php   					 print "<option value=\"{$row_rs_industry['industry_id']}\"" .					(isset($_GET['industry_id']) && $_GET['industry_id'] == $row_rs_industry['industry_id'] ? " selected>" : ">") .    					 "{$row_rs_industry['industry_name']}</option>\n";?>				  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?>				</select></td></tr>				 <tr><td>Product category:</td><td>				 				 <?php if ($_GET['industry_id'] == null || $_GET['industry_id'] == "") { ?>				 <select name="productCat_id" id="center" onchange="document.distributers.value='productCat_id';document.distributers.submit();" disabled>;				 <?php } else { 					mysql_select_db($database_conn_dj, $conn_dj);					$query_rs_productcategory = "SELECT productCat_id, productCat_name, industry_id FROM tbl_productcat WHERE industry_id = '$_GET[industry_id]' ORDER BY productCat_name";					$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());					$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);					$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);				 ?>			 			<select name="productCat_id" id="center" onchange="document.distributers.value='productCat_id';document.distributers.submit();" >				  <option value="">Select a product category...</option>				<?php do {   					 print "<option value=\"{$row_rs_productcategory['productCat_id']}\"" .					(isset($_GET['productCat_id']) && $_GET['productCat_id'] == $row_rs_productcategory['productCat_id'] ? " selected>" : ">") .    					 "{$row_rs_productcategory['productCat_name']}</option>\n";				 } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?>				</select>		 		<?php } ?></td>								<tr><td>Product:</td><td>									 <?php if ($_GET['productCat_id'] == null || $_GET['productCat_id'] == "" || $_GET['industry_id'] == null || $_GET['industry_id'] == "") { ?>				 <select name="product_id" id="center" onchange="document.distributers.value='products_id';document.distributers.submit();" disabled>;				 <?php } else { 						mysql_select_db($database_conn_dj, $conn_dj);					$query_rs_product = "SELECT products_id, products_name, productCat_id FROM tbl_products WHERE productCat_id = '$_GET[productCat_id]' ORDER BY products_name";					$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());					$row_rs_product = mysql_fetch_assoc($rs_product);					$totalRows_rs_product = mysql_num_rows($rs_product);					?>		 			<select name="products_id" id="center" onchange="document.distributers.value='products_id';document.distributers.submit();" >				  <option value="">Select a product...</option>					<?php do {	   					 print "<option value=\"{$row_rs_product['products_id']}\"" .						(isset($_GET['products_id']) && $_GET['products_id'] == $row_rs_product['products_id'] ? " selected>" : ">") . 	   					 "{$row_rs_product['products_name']}</option>\n";					 } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>					</select>				<?php } ?> 									</td></tr>				<tr><td> </td><td><input type="submit" value="Find" name="find"></td></tr>		  </table>			</form>						<br />		 <h2>Outside North America </h2>	<table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">		 <tr><td>  			  <select name="outna" id="center" onchange="java script:document.centerform.submit()">				 <option value="">Select a country...</option>				 				 <?php do { ?>				 <?php   					 print "<option value=\"{$row_rs_outsidena['id']}\"" .					(isset($_GET['id']) && $_GET['id'] == $row_rs_outsidena['id'] ? " selected>" : ">") .    					 "{$row_rs_outsidena['name']}</option>\n";?>								   <?php } while ($row_rs_outsidena = mysql_fetch_assoc($rs_outsidena)); ?> </select>		  </td></tr>		  </table>		</form>		</div>	</div>	<?php include("_inc/footer.inc"); ?></body></html><?phpmysql_free_result($rs_industry);mysql_free_result($rs_productcategory);mysql_free_result($rs_product);mysql_free_result($rs_outsidena);?>

Hey is it possible to run a query and not allow the others to run until the ones above it have been executed like on page load i only want one thing to load and as the user submits then run the next on and so on here is my code if its possible ot change it i would appreciate any tips..

mysql_select_db($database_conn_dj, $conn_dj);$query_rs_industry = "SELECT industry_id, industry_name FROM tbl_industry ORDER BY industry_name ASC";$rs_industry = mysql_query($query_rs_industry, $conn_dj) or die(mysql_error());$row_rs_industry = mysql_fetch_assoc($rs_industry);$totalRows_rs_industry = mysql_num_rows($rs_industry);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_productcategory = "SELECT productCat_id, productCat_name, industry_id FROM tbl_productcat WHERE industry_id = '$_GET[industry_id]' ORDER BY productCat_name";$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_product = "SELECT products_id, products_name, productCat_id FROM tbl_products WHERE productCat_id = '$_GET[productCat_id]' ORDER BY products_name";$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());$row_rs_product = mysql_fetch_assoc($rs_product);$totalRows_rs_product = mysql_num_rows($rs_product);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_outsidena = "SELECT * FROM intl_countries ORDER BY intl_countries.name";$rs_outsidena = mysql_query($query_rs_outsidena, $conn_dj) or die(mysql_error());$row_rs_outsidena = mysql_fetch_assoc($rs_outsidena);$totalRows_rs_outsidena = mysql_num_rows($rs_outsidena);

Hey I'm having a slight problem with my query of my php databse. It works but for some reason the code is messing up my css and totally enlarging the text until it submits the first time. After the first submit it works fine everything goes back to normal? here is my code any suggestions?

mysql_select_db($database_conn_dj, $conn_dj);$query_rs_productcategory = "SELECT productCat_id, productCat_name, industry_id FROM tbl_productcat WHERE industry_id = '$_GET[industry_id]' ORDER BY productCat_name";$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_product = "SELECT products_id, products_name, productCat_id FROM tbl_products WHERE productCat_id = '$_GET[productCat_id]' ORDER BY products_name";$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());$row_rs_product = mysql_fetch_assoc($rs_product);$totalRows_rs_product = mysql_num_rows($rs_product);

now i get ... Parse error: syntax error, unexpected '{', expecting ',' or ';' in /u/internet/com/dickeyjohn/test.php on line 76and

 <?php do { ?>				 <option value="<?=$row_rs_industry['industry_id'];?>"<?=(isset($_GET['industry_id']) && $_GET['industry_id'] == $row_rs_industry['industry_id']) { ?> selected<?php } ?>><?=$row_rs_industry['industry_name'];?></option>

thats the line of code

Hey on one of my projects i keep getting undefined indexes because the user has to select a drop down value first how do i just give it a fake value like test or something ahead of time??

Hey I have 3 questions in one here. First off when my dropdowns submit their value and the page refreshes they go back to their original value which says select a value but I want them to stay on the value the user selects. Also if the user refreshes the page or changes the value of one of the dropdowns I want all the corresponding ones below to automatically repopulate. Finally I want them to be disabled until a user selects the value that will populate it and I am having issues with the if loops. Can someone look at this code and help me with this stuff?

<form name="distributers">			  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td>Industry:</td><td>								<select name="industry_id" id="industry" onchange="document.distributers.value='industry';document.distributers.submit();" >				  <option value="">Select an Industry...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_industry['industry_id']; ?>"><?php echo $row_rs_industry['industry_name']; ?></option>				  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?>				</select></td></tr>				 <tr><td>Product category:</td><td>						 			<select name="productCat_id" id="center" onchange="document.distributers.value='productCat_id';document.distributers.submit();" >				  <option value="">Select a product category...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_productcategory['productCat_id']; ?>"><?php echo $row_rs_productcategory['productCat_name']; ?></option>				  				  <?php } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?>				</select> <tr><td>Products:</td><td>					<select name="product" id="center" onchange="document.distributers.value='products_id';document.distributers.submit();" >				  <option value="">Select a product...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_product['products_id']; ?>"><?php echo $row_rs_product['products_name']; ?></option>				  <?php } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>					</select> <tr><td>State:</td><td>				<select name="state" id="center" >				<option value="">Select a state...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_state['state']; ?>"><?php echo $row_rs_state['state']; ?></option>				  <?php } while ($row_rs_state = mysql_fetch_assoc($rs_state)); ?>					</select>					</td></tr>				<tr><td> </td><td><input class="PythonButton" type="submit" value="Find" name="{Button_Name}"></td></tr>		  </table>			</form>

that didnt work grr i tried some more things this is really annoying lol here is my code

<?php require_once('Connections/conn_dj.php'); ?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);  switch ($theType) {	case "text":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;		case "long":	case "int":	  $theValue = ($theValue != "") ? intval($theValue) : "NULL";	  break;	case "double":	  $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";	  break;	case "date":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;	case "defined":	  $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;	  break;  }  return $theValue;}}mysql_select_db($database_conn_dj, $conn_dj);$query_rs_industry = "SELECT * FROM tbl_industry ORDER BY industry_name ASC";$rs_industry = mysql_query($query_rs_industry, $conn_dj) or die(mysql_error());$row_rs_industry = mysql_fetch_assoc($rs_industry);$totalRows_rs_industry = mysql_num_rows($rs_industry);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_productcategory = "SELECT * FROM tbl_productcat WHERE industry = ".$_GET['industry_id']."";$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_product = "SELECT * FROM tbl_products ORDER BY tbl_products.products_name";$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());$row_rs_product = mysql_fetch_assoc($rs_product);$totalRows_rs_product = mysql_num_rows($rs_product);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_outsidena = "SELECT * FROM intl_countries ORDER BY intl_countries.name";$rs_outsidena = mysql_query($query_rs_outsidena, $conn_dj) or die(mysql_error());$row_rs_outsidena = mysql_fetch_assoc($rs_outsidena);$totalRows_rs_outsidena = mysql_num_rows($rs_outsidena);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_state = "SELECT * FROM tbl_states ORDER BY tbl_states.`state`";$rs_state = mysql_query($query_rs_state, $conn_dj) or die(mysql_error());$row_rs_state = mysql_fetch_assoc($rs_state);$totalRows_rs_state = mysql_num_rows($rs_state);?><!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>DICKEY-john Corporation | Distributors</title><link href="_lib/sub.css" rel="stylesheet" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="keywords" content="Distributor, Sales, Purchase, U.S., International" /><meta name="description" content="Enter your zip or postal code to find the DICKEY-john distributor nearest you." /></head><body> <div id="black"> </div><div id="siteContainer">	<?php include("_inc/topNav.inc"); ?>	<div id="headerContainer">Distributors</div>	<div class="divContainer"><div class="horizDiv"></div><img src="/_img/divEnd.png" alt="div" height="16" width="4" align="right" /></div>	<div id="contentContainer">		<div id="fullContainer">			<div id="stretchCrumbs">				<a href="/index.php">Home</a>				» <a class="high" href="/distributors/">Distributors</a>			</div>			<h1>Distributors</h1>			<p>Search for DICKEY-john distributers by specifying any combonation of the<br />			following classifications: industry, product category, product, and state.</p>			<br />						<br />												<h2>North America</h2>			<form name="distributers">			  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td>Industry:</td><td>								<select name="industry" id="industry" onchange="document.distributers.value='industry';document.distributers.submit();" >				  <option value="">Select an Industry...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_industry['industry_id']; ?>"><?php echo $row_rs_industry['industry_name']; ?></option>				  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?>				</select></td></tr>				 <tr><td>Product category:</td><td>						 			<select name="prodcat" id="center" disabled>				  <option value="">Select a product category...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_productcategory['productCat_name']; ?>"><?php echo $row_rs_productcategory['productCat_name']; ?></option>				  				  <?php } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?>				</select> <tr><td>Products:</td><td>					<select name="product" id="center" disabled >				  <option value="">Select a product...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_product['products_name']; ?>"><?php echo $row_rs_product['products_name']; ?></option>				  <?php } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>					</select> <tr><td>State:</td><td>				<select name="state" id="center" disabled >				<option value="">Select a state...</option>				<?php do { ?>				  <option value="<?php echo $row_rs_state['state']; ?>"><?php echo $row_rs_state['state']; ?></option>				  <?php } while ($row_rs_state = mysql_fetch_assoc($rs_state)); ?>					</select>					</td></tr>				<tr><td> </td><td><input class="PythonButton" type="submit" value="Find" name="{Button_Name}"></td></tr>		  </table>			</form>						<br />		 <h2>Outside North America </h2>	<table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">		 <tr><td>  <select name="outna" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a country...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_ousidena['name']; ?>"><?php echo $row_rs_outsidena['name']; ?></option>				  <?php } while ($row_rs_outsidena = mysql_fetch_assoc($rs_outsidena)); ?>				  		  </select></td> 			</tr></td></tr>		  </table>		</form>		</div>	</div><?php include("_inc/footer.inc"); ?></body></html><?phpmysql_free_result($rs_industry);mysql_free_result($rs_productcategory);mysql_free_result($rs_product);mysql_free_result($rs_outsidena);mysql_free_result($rs_state);?>

Hey guys this might be just a noob question but in my sql query for the database how do i set it to say like where industry = and then the id number from the url for its query?

There's nothing wrong with that code itself. With all of the IDs and the hidden element, it looks like javascript is accessing the elements, so there's probably some problem where the javascript either gets an unexpected value, or is missing a value. But that code is syntactically correct.

<form id="search" method="GET" action="/search/index.php">			<input id="searchBox" type="text" name="zoom_query" value="Search" onFocus="clearText(this)"/>			<input type="hidden" name="zoom_and" value="1" />			<input id="searchSubmit" type="image" src="/_img/arrow_search.jpg" alt="site search arrow" />		</form>

Something in that line is what is causing my problem when i remove it from the page it works again!

So you include the topNav.inc, and then the code in chainedselects or exampleconfig stops working? It looks like some divs are not being closed, so if the javascript is trying to access certain divs, it might be confused as to where they end. It looks like the siteContainer, contentContainer, and fullContainer divs are not being closed.

Ok try something like this.You'll obviously change the names to what you have in your database and add an action to the form. You can probably find a simple javascript to submit each feild automatically when the user selects something and so it remembers what they selected in each dropdown.But here is the general logic I could come up with. It should be a decent start if you know php :)P.S. I havnt tested it yet.

<html><body><form><select name="industry"><option value="">---Industry---</option><?PHP	$query="SELECT * from dropdown1";	$results = mysql_query($query);	while ($e=mysql_fetch_array($results)) {	 echo "<option value='".$e[one_value]."'>".$e[one_value]."</option>";	}?></select><select name="product_cat"<?PHPif ($_REQUEST['industry'] != "") {echo ">";}else { echo "disabled>";}  $query="SELECT two_value from dropdown2 where dropdown_one_id=$_REQUEST[dropdown1]";  $results = mysql_query($query);   while ($e=mysql_fetch_array($results)) {	echo "option value='".$e[two_value]."'>".$e[two_value]."</option>";   }?></form></body></html>

<!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>DICKEY-john Corporation | Distributors</title><link href="_lib/sub.css" rel="stylesheet" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="keywords" content="Distributor, Sales, Purchase, U.S., International" /><meta name="description" content="Enter your zip or postal code to find the DICKEY-john distributor nearest you." /><script language="javascript" src="chainedselects.js"></script><script language="javascript" src="exampleconfig.js"></script></head><body onload="initListGroup('vehicles', document.forms[0].make, document.forms[0].type, document.forms[0].model)"><div id="black"> </div><div id="siteContainer">	<?php include("_inc/topNav.inc"); ?><div id="headerContainer">Distributors</div>	<div class="divContainer"><div class="horizDiv"></div><img src="/_img/divEnd.png" alt="div" height="16" width="4" align="right" /></div>	<div id="contentContainer">		<div id="fullContainer">			<div id="stretchCrumbs">				<a href="/index.php">Home</a>				» <a class="high" href="/distributors/">Distributors</a>			</div>			<h1>Distributors</h1>			<p>Search for DICKEY-john distributers by specifying any combonation of the<br />			following classifications: industry, product category, product, and state.</p>			<br />				<h2>North America</h2><table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0"><tr><td><form><table align="center"><tr><td>Industry:</td><td><select name="make"></select></td></tr><tr><td>Product Category: </td><td><select name="type"></select></td></tr><tr><td>Product:</td><td><select name="model"></select></td></tr><td><input type="button" value="Reset" onclick="resetListGroup('vehicles')"></tr></table></form></body></html>

here is the include file..

	<script>		function clearText(thefield){		if (thefield.defaultValue==thefield.value)		thefield.value = ""		} 	</script><div id="menuContainer">		<form id="search" method="GET" action="/search/index.php">			<input id="searchBox" type="text" name="zoom_query" value="Search" onFocus="clearText(this)"/>			<input type="hidden" name="zoom_and" value="1" />			<input id="searchSubmit" type="image" src="/_img/arrow_search.jpg" alt="site search arrow" />		</form>				<div id="topTidbits"><!--ZOOMSTOP-->		<a href="/index.php">Home</a> | <a href="/aboutus/">About Us</a> | <a href="/pressroom/">Pressroom</a> | <a href="/shows/">Trade Shows</a> | <a href="/employment/">Employment</a> | <!--<a href="/pressroom/catalogs/">Catalogs</a> |--> <a href="/sitemap/">Site Map</a><!--ZOOMRESTART--></div>		<table id="navTbl" border="0" cellpadding="0" cellspacing="0">			<tr><!--ZOOMSTOP-->			<td class="nav"><a href="/products/">PRODUCTS</a></td>			<td class="nav"><a href="/distributors/">DISTRIBUTORS</a></td>			<td class="nav"><a href="/full-circle-manufacturing/">FULL CIRCLE MANUFACTURING</a></td>			<td class="nav navEnd"><a href="/contact/">CONTACT US</a></td>			<!--ZOOMRESTART-->			</tr>		</table>		</div>

It'd probably be best to put the state first, so you don't have to worry about using javascript to disable it, since its a static value.

How many levels are there going to be? 3 levels?Also, do you have the database created already?

It is very much possible to make them database driven. I'm sure you can just add some database interaction instead it being hardcoded. You posted in the php forum so im assuming you are using php and mysql for the database. I can help you out if you are having problems with the queries. It shouldnt be too difficult :)Good luck!

Check out this linkClick Me!Thats a "tutorial"Its not really a tutorial, they give you the code in a zip file, but I think thats the sort of thing you want.

Hey guys i have a select menu that i would like to on change submit its value to the page test2.php and on page 2 the value will populate the next select list any help?

tell yuor boss you cant do it because you dont know how to, or ask a programmer at your work place to do it. It probably wouldnt take them too long.

Hey guys, How would I make my page I have connect to a database using javascript dependent dropdowns? I have all the things I need to get the database working where it displays all the info in the database but I only want it to display based on what they select not all of it. Here is my page any help would be greatly appreciated.

<?php require_once('Connections/conn_dj.php'); ?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);  switch ($theType) {	case "text":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;		case "long":	case "int":	  $theValue = ($theValue != "") ? intval($theValue) : "NULL";	  break;	case "double":	  $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";	  break;	case "date":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;	case "defined":	  $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;	  break;  }  return $theValue;}}mysql_select_db($database_conn_dj, $conn_dj);$query_rs_industry = "SELECT * FROM tbl_industry ORDER BY industry_name ASC";$rs_industry = mysql_query($query_rs_industry, $conn_dj) or die(mysql_error());$row_rs_industry = mysql_fetch_assoc($rs_industry);$totalRows_rs_industry = mysql_num_rows($rs_industry);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_productcategory = "SELECT * FROM tbl_productcat  ORDER BY tbl_productcat.productCat_name";$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_product = "SELECT * FROM tbl_products ORDER BY tbl_products.products_name";$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());$row_rs_product = mysql_fetch_assoc($rs_product);$totalRows_rs_product = mysql_num_rows($rs_product);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_outsidena = "SELECT * FROM intl_countries ORDER BY intl_countries.name";$rs_outsidena = mysql_query($query_rs_outsidena, $conn_dj) or die(mysql_error());$row_rs_outsidena = mysql_fetch_assoc($rs_outsidena);$totalRows_rs_outsidena = mysql_num_rows($rs_outsidena);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_state = "SELECT * FROM tbl_states ORDER BY tbl_states.`state`";$rs_state = mysql_query($query_rs_state, $conn_dj) or die(mysql_error());$row_rs_state = mysql_fetch_assoc($rs_state);$totalRows_rs_state = mysql_num_rows($rs_state);?><!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>DICKEY-john Corporation | Distributors</title><link href="_lib/sub.css" rel="stylesheet" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="keywords" content="Distributor, Sales, Purchase, U.S., International" /><meta name="description" content="Enter your zip or postal code to find the DICKEY-john distributor nearest you." /></head><body><div id="black"> </div><div id="siteContainer">	<?php include("_inc/topNav.inc"); ?>	<div id="headerContainer">Distributors</div>	<div class="divContainer"><div class="horizDiv"></div><img src="/_img/divEnd.png" alt="div" height="16" width="4" align="right" /></div>	<div id="contentContainer">		<div id="fullContainer">			<div id="stretchCrumbs">				<a href="/index.php">Home</a>				» <a class="high" href="/distributors/">Distributors</a>			</div>			<h1>Distributors</h1>			<p>Search for DICKEY-john distributers by specifying any combonation of the<br />			following classifications: industry, product category, product, and state.</p>			<br />						<br />													<h2>North America</h2>						  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td>Industry:</td><td>				<select name="industry" id="center">				  <option value="">Select an Industry...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_industry['industry_name']; ?>"><?php echo $row_rs_industry['industry_name']; ?></option>				  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?>				</select></td></tr>				<tr><td width="125">Product Category: </td>  <td>				<select name="prodcat" id="center">				  <option value="">Select a product category...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_productcategory['productCat_name']; ?>"><?php echo $row_rs_productcategory['productCat_name']; ?></option>				  				  <?php } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?>				</select></td></tr>				<tr>				<td>Product:</td>   <td>				<select name="prod" id="center">				  <option value="">Select a product...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_product['products_name']; ?>"><?php echo $row_rs_product['products_name']; ?></option>				  <?php } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>			  				</select>	</td></tr>				<td>State:</td>				  <td> <select name="state" id="center">				  <option value="">Select a state...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_state['state']; ?>"><?php echo $row_rs_state['state']; ?></option>				  <?php } while ($row_rs_state = mysql_fetch_assoc($rs_state)); ?>				 				</select></td>						  </tr>				<tr><td> </td><td><input class="PythonButton" type="submit" value="Find" name="{Button_Name}"></td></tr>		  </table>			</form>						<br />		 <h2>Outside North America </h2>	<table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">		 <tr><td>  <select name="outna" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a country...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_ousidena['name']; ?>"><?php echo $row_rs_outsidena['name']; ?></option>				  <?php } while ($row_rs_outsidena = mysql_fetch_assoc($rs_outsidena)); ?>				  		  </select></td> 			</tr></td></tr>		  </table>		</form>		</div>	</div><?php include("_inc/footer.inc"); ?></body></html><?phpmysql_free_result($rs_industry);mysql_free_result($rs_productcategory);mysql_free_result($rs_product);mysql_free_result($rs_outsidena);mysql_free_result($rs_state);?>

Well, there are a lot of pieces to this. The first one is removing all the options from a select list. Whenever you make a change, you will want to remove all the options, then add new ones. This is how you remove options:http://www.w3schools.com/htmldom/met_select_remove.aspYou will use the size property of the select list to remove all of them:

for (i = document.getElementById("dropdown1").size - 1; i >= 0; i--)  document.getElementById("dropdown1").remove(i);

That should remove everything. The next thing to do is add all the new options. Here is a page about adding and removing options:http://www.mredkj.com/tutorials/tutorial005.htmlThis is the code they use:

	var elOptNew = document.createElement('option');	elOptNew.text = 'Insert' + num;	elOptNew.value = 'insert' + num;	var elOptOld = elSel.options[elSel.selectedIndex];  	try {	  elSel.add(elOptNew, elOptOld); // standards compliant; doesn't work in IE	}	catch(ex) {	  elSel.add(elOptNew, elSel.selectedIndex); // IE only	}

Once you can remove and add the options, the next part is figuring out which options you need to add. So, you need to check what the value of the previous dropdown list is, and use an IF statement to add the appropriate new options. This is where the PHP will come into play, you will write out each IF statement with PHP to add the appropriate options based on the value that was selected in the other list.

If you want this to be purely client-side (instead of resubmitting the page whenever they change a dropdown), you will need to write out all of the javascript code that will change the dropdowns. You'll probably need one javascript function for each of the three dropdowns that changes another one, and each javascript function will need to read which value you chose, and populate the next list with options. You can search for the code on how to add and remove options from a dropdown, that is pretty common. But you will need to write out all of your database data in the javascript functions, inside a javascript array or something so that the function can go through the array and add the various items to the list.So, in other words, you need to use PHP to write out Javascript code that will clear out the dropdown and add the new items. The difficult part will be structuring your data in the Javascript functions so that it works like you want. While developing, take a look at your Javascript code and use a Javascript console like Opera or Firefox has to track down Javascript errors.

Hello, i'm working on a website and i have 4 dropdown's that are on a page and i want to make them dependent. Right now i have them set to pull from the database but i want it set to based on what they select on number 1 it populates number 2 and number 2 populates 3 and 3 does 4 and so on. Can someone take a look at my code and help me to achieve this as i have never done it before and would appreciate any help at all..

<?php require_once('Connections/conn_dj.php'); ?><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);  switch ($theType) {	case "text":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;		case "long":	case "int":	  $theValue = ($theValue != "") ? intval($theValue) : "NULL";	  break;	case "double":	  $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";	  break;	case "date":	  $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";	  break;	case "defined":	  $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;	  break;  }  return $theValue;}}mysql_select_db($database_conn_dj, $conn_dj);$query_rs_industry = "SELECT * FROM tbl_industry ORDER BY industry_name ASC";$rs_industry = mysql_query($query_rs_industry, $conn_dj) or die(mysql_error());$row_rs_industry = mysql_fetch_assoc($rs_industry);$totalRows_rs_industry = mysql_num_rows($rs_industry);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_productcategory = "SELECT * FROM tbl_productcat  ORDER BY tbl_productcat.productCat_name";$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_product = "SELECT * FROM tbl_products ORDER BY tbl_products.products_name";$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());$row_rs_product = mysql_fetch_assoc($rs_product);$totalRows_rs_product = mysql_num_rows($rs_product);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_outsidena = "SELECT * FROM intl_countries ORDER BY intl_countries.name";$rs_outsidena = mysql_query($query_rs_outsidena, $conn_dj) or die(mysql_error());$row_rs_outsidena = mysql_fetch_assoc($rs_outsidena);$totalRows_rs_outsidena = mysql_num_rows($rs_outsidena);mysql_select_db($database_conn_dj, $conn_dj);$query_rs_state = "SELECT * FROM tbl_states ORDER BY tbl_states.`state`";$rs_state = mysql_query($query_rs_state, $conn_dj) or die(mysql_error());$row_rs_state = mysql_fetch_assoc($rs_state);$totalRows_rs_state = mysql_num_rows($rs_state);?><!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>DICKEY-john Corporation | Distributors</title><link href="_lib/sub.css" rel="stylesheet" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><meta name="keywords" content="Distributor, Sales, Purchase, U.S., International" /><meta name="description" content="Enter your zip or postal code to find the DICKEY-john distributor nearest you." /></head><body><div id="black"> </div><div id="siteContainer">	<?php include("_inc/topNav.inc"); ?>	<div id="headerContainer">Distributors</div>	<div class="divContainer"><div class="horizDiv"></div><img src="/_img/divEnd.png" alt="div" height="16" width="4" align="right" /></div>	<div id="contentContainer">		<div id="fullContainer">			<div id="stretchCrumbs">				<a href="/index.php">Home</a>				» <a class="high" href="/distributors/">Distributors</a>			</div>			<h1>Distributors</h1>			<p>Search for DICKEY-john distributers by specifying any combonation of the<br />			following classifications: industry, product category, product, and state.</p>			<br />						<br />													<h2>North America</h2>						  <table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">				<tr><td>Industry:</td><td>				<select name="industry" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select an Industry...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_industry['industry_name']; ?>"><?php echo $row_rs_industry['industry_name']; ?></option>				  				  <?php } while ($row_rs_industry = mysql_fetch_assoc($rs_industry)); ?></td></tr>				</select>				<tr><td width="125">Product Category: </td>  <td>				<select name="prodcat" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a product category...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_productcategory['productCat_name']; ?>"><?php echo $row_rs_productcategory['productCat_name']; ?></option>				  				  <?php } while ($row_rs_productcategory = mysql_fetch_assoc($rs_productcategory)); ?></td></tr>				</select>				<tr>				<td>Product:</td><td>				<select name="prod" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a product...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_product['products_name']; ?>"><?php echo $row_rs_product['products_name']; ?></option>				  <?php } while ($row_rs_product = mysql_fetch_assoc($rs_product)); ?>				  </td></tr>				</select>				<td>State:</td>				  <td> <select name="state" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a state...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_state['state']; ?>"><?php echo $row_rs_state['state']; ?></option>				  <?php } while ($row_rs_state = mysql_fetch_assoc($rs_state)); ?>				  </td></tr>				</select></td>						  </tr>				<tr><td> </td><td><input class="PythonButton" type="submit" value="Find" name="{Button_Name}"></td></tr>		  </table>			</form>						<br />		 <h2>Outside North America </h2>	<table class="setTbl listTbl" width="90%" cellpadding="0" cellspacing="0" border="0">		 <tr><td>  <select name="outna" id="center" onchange="java script:document.centerform.submit()">				  <option value="">Select a country...</option>				  <?php do { ?>				  <option value="<?php echo $row_rs_ousidena['name']; ?>"><?php echo $row_rs_outsidena['name']; ?></option>				  <?php } while ($row_rs_outsidena = mysql_fetch_assoc($rs_outsidena)); ?>				  </td></tr>		  </select></td> 			</tr></td></tr>		  </table>		</form>		</div>	</div><?php include("_inc/footer.inc"); ?></body></html><?phpmysql_free_result($rs_industry);mysql_free_result($rs_productcategory);mysql_free_result($rs_product);mysql_free_result($rs_outsidena);mysql_free_result($rs_state);?>

Hey guys i'm trying to update another site that was designed in 2004 and very outdated on the page for contact it has the following line:

 <?phpif ($_SESSION['inquirySuccess']) {echo "<tr><td valign=\"top\" colspan=\"2\" bgcolor=\"#FFFF99\"><p><strong>Thank you for your question.<br />  A Brintlinger and Earl representative will be in contact with you shortly.</strong></p></td><td> </td></tr><tr><td> </td><td> </td><tr>"; session_unset();session_destroy();}?> 

This line throws the error:Notice: Undefined index: inquirySuccess in /u/internet/com/brintlinger-earl/includes/content/submit_contact.php on line 6My question is why does it have this error, and how can i get rid of it?