not an expert but from some things that I've done... When you handle the selection use JS and set a hidden field on your form wiht the choice. Do the same with your second dropdown and then let them click on a 'submit' <input> "Fahim Mohammad" <fahim.md@xxxxxxxxx> wrote in message news:BANLkTim47cjrUsXYz=t-Yfhaoz_iUntesA@xxxxxxxxxxxxxxxxx > Hi Php users, > I have a form that has two (has more but for sake of brevity I am assuming > it to be two) dropdown menu. > > menu 1: select organism. > > menu 2: select genome. This menu depends on the selected value in the > first > menu. It query into database and populate the result in this menu. > > Once both are selected, I want a submit button that takes me to another > page > where I can process these values to perform some specific task on the > database. > > I am using the following form tag > > <form name="theForm" method="get" enctype="multipart/form-data" action = > 'processForm.php' > > > I have the following problem now: > > 1. If I keep the action value in the form tag above, after selecting the > first option it direct me to the second page and I am not able to select > the > seconf option in the form. > > > 2. If I remove the action value above then I can not submit the form as > intended. > > 3. If I remove the "onChange="autoSubmit();"" from select tag then I am > not > able to pass the selected value in first option to mysql to get the > result. > > I think I reached a place from where it is not possible for me to proceed > ahead. I may need to change something which I am not aware of. > > Help needed. > Thanks > > [php] > <?php > include'login.php'; > $conn = mysql_connect($db_hostname, $db_username, $db_password ); > $db = mysql_select_db('rugit',$conn); > if (!$db) die("Unable to connect to MySQL: " . mysql_error()); > ?> > > <?php > $organism = $genomeVer = null; //declare vars > if(isset($_GET["organism"]) && is_string($_GET["organism"])) > { > $organism = $_GET["organism"]; > } > if(isset($_GET["genomeVer"]) && is_string($_GET["genomeVer"])) > { > $genomeVer = $_GET["genomeVer"]; > } > ?> > > <script language="JavaScript"> > function autoSubmit() > { > var formObject = document.forms['theForm']; > formObject.submit(); > } > </script> > > <!-- Form tag --> > <form name="theForm" method="get" enctype="multipart/form-data" > > > <!-- Option 1: Select the organism --> > <select name="organism" onChange="autoSubmit();"> > <option value="null">Select Organism</option> > <option value= "human" <?php if(strcmp($organism, "human") == 0) echo > " selected"; ?>>human</option> > <option value= "mouse" <?php if(strcmp($organism, "mouse") == 0) echo > " selected"; ?>>mouse</option> > <option value= "rat" <?php if(strcmp($organism,"rat") == 0) echo " > selected"; ?>>rat</option> > </select> <br></br> > > <!--Option 2: select the genome --> > <?php > //POPULATE DROP DOWN MENU FOR Genome version corresponding to a > given organism > $sql = "SELECT genomeVer FROM organismGenomeVer WHERE organism = > \"$organism\""; > $result = mysql_query($sql,$conn); > ?> > <br> > <select name="genomeVer" onChange="autoSubmit();"> > <option value="null">genomeVer</option> > <?php > while($row = mysql_fetch_array($result)) > { > echo ("<option value=\"$row[0]\" " . ($genomeVer == > $row["0"] ? " selected" : "") . ">$row[0]</option>"); > } > mysql_free_result($result); > echo"</select>"; > ?> > <!-- Submit button --> > <br></br> > <input type="submit" value="submit" class="html-text-box"> > </form> > > [/php] > > > -- > Fahim > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
