Problem Solved! Just explaining this problem in the posting helped me a lot. Here is the code that works, if anyone wants it. A very useful page for MySQL data and dropdown menus. I wasn't getting the selected product form the get method, and I need to fix it where the post loadTable wasn't an elseif statement.
I'm not trying to format the code again. Copying and pasting into a php editor should do the trick. Tanya Holliday <?php /* http://productSearch.php */ // INCLUDE THE MYSQL DATABASE CONNECTION FILE require_once('/conn_db.php'); // MAKE A CONNECTION TO THE DATABASE BEFORE ANY EVENTS CAN HAPPEN if(!$result = conn_db()) { echo 'Could not make a connection to the database'; exit; } // IF A PRODUCT HAS BEEN SELECTED if($_GET['do'] == 'chproduct' || $_GET['do'] == "loadTable") { // THEN GET WHICH PRODUCT WAS SELECTED if($_GET['product']) $product = $_GET['product']; else $product = $_POST['product']; if($product == 4) { // GATHER ALL FORM FACTORS FOR GRAPHICS AND VIDEO PRODUCTS $query_ff = "SELECT DISTINCT `Form Factor` FROM product_families ORDER BY `Form Factor` ASC"; // QUERY DATABASE, GATHER RESULTS IN AN ARRAY, THEN COUNT THE NUMBER OF FORM FACTORS IN ARRAY $fFactors = @ mysql_query($query_ff); $row_fFactors = @ mysql_fetch_assoc($fFactors); $totalRows_fFactors = @ mysql_num_rows($fFactors); // GATHER ALL GRAPHIC PROCESSORS FOR GRAPHICS AND VIDEO RODUCTS $query_gp = "SELECT DISTINCT `Graphics Processor` FROM product_families ORDER BY `Graphics Processor` ASC"; // QUERY DATABASE, GATHER RESULTS IN AN ARRAY, THEN COUNT THE NUMBER OF GRAPHIC PROCESSORS IN ARRAY $gProcessors = @ mysql_query($query_gp); $row_gProcessors = @ mysql_fetch_assoc($gProcessors); $totalRows_gProcessors = @ mysql_num_rows($gProcessors); // GATHER ALL SOFTWARE SUPPORT OS FOR GRAPHICS AND VIDEO RODUCTS $query_ss = "SELECT DISTINCT `Software Support` FROM product_families ORDER BY `Software Support` ASC"; // QUERY DATABASE, GATHER RESULTS IN AN ARRAY, THEN COUNT THE NUMBER OF SOFTWARE SUPPORT OS IN ARRAY $softSupport = @ mysql_query($query_ss); $row_softSupport = @ mysql_fetch_assoc($softSupport); $totalRows_softSupport = @ mysql_num_rows($softSupport); // GATHER ALL RUGGEDIZATIONS OS FOR GRAPHICS AND VIDEO RODUCTS $query_rg = "SELECT DISTINCT Ruggedization FROM product_families ORDER BY Ruggedization ASC"; // QUERY DATABASE, GATHER RESULTS IN AN ARRAY, THEN COUNT THE NUMBER OF RUGGEDIZATION IN ARRAY $rugged = mysql_query($query_rg); $row_rugged = mysql_fetch_assoc($rugged); $totalRows_rugged = mysql_num_rows($rugged); } // ALSO DID A GRAPHICS AND VIDEO PRODUCT SPECIFICATION GET SELECTED TO LOAD TABLE if($_GET['do'] == "loadTable") { $query = "Select * FROM product_families WHERE "; if($_POST['form_factors']) { $currentFormFactor = $_POST['form_factors']; $query .= "`Form Factor`= '".$currentFormFactor."'"; } if($_POST['graphic_proc']) { $currentGraphicProcessor = $_POST['graphic_proc']; if($currentFormFactor) $query .= " AND `Graphics Processor` LIKE '".$currentGraphicProcessor."'"; else $query .= "`Graphics Processor` LIKE '".$currentGraphicProcessor."'"; } if($_POST['soft_support']) { $currentSoftwareSupport = $_POST['soft_support']; if($currentFormFactor || $currentGraphicProcessor) $query .= " AND `Software Support` LIKE '".$currentSoftwareSupport."%'"; else $query .= "`Software Support` LIKE '".$currentSoftwareSupport."'"; } if($_POST['ruggedization']) { $currentRuggedization = $_POST['ruggedization']; if($currentFormFactor || $currentGraphicProcessor || $currentRuggedization) $query .= " AND Ruggedization LIKE '".$currentSoftwareSupport."'"; else $query .="Ruggedization LIKE '".$currentSoftwareSupport."'"; } $tableResults = mysql_query($query); } } // GET LIST OF PRODUCTS TO LOAD IN FIRST SELECT MENU $query_products = "SELECT product_type_id, product_type FROM productType"; // QUERY DATABASE, GATHER RESULTS IN AN ARRAY, THEN COUNT THE NUMBER OF PRODUCTS IN ARRAY $products = mysql_query($query_products); $row_products = mysql_fetch_assoc($products); $totalRows_products = mysql_num_rows($products); ?> <!-- INSERT CODE FOR HTML PAGE AND DESIGN --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <html> <head> <title></title> </head> <body> <table width="100%"> <tr> <td colspan="2"> <!-- SET THE FORM ACTION TO ENVOKE THE GET do TO CHANGE PRODUCT NAMES --> <form name="productForm" id="productForm" method="post" action="<?php echo $SERVER['PHP_SELF']; ?>?do=chproduct"> <label for="product"><big>Products: </big></label> <select name="product" id="product" onChange="javascript:document.productForm.submit()"> <option value="">Select A Product...</option> <?php do {// ROW_PRODUCTS IS AN ARRAY OF PROEUCT NAMES echo '<option value="'.$row_products['product_type_id'].'"'; // IS PRODUCT_ID THE CURRENT PRODUCT SELECTED if(!(strcmp($row_products['product_type_id'], "$product"))) echo ' selected="SELECTED">'.$row_products['product_type']."</option>\n"; else echo '>'.$row_products['product_type']."</option>\n"; // GET ALL PRODUCT NAMES FROM THE ARRAY }while($row_products = mysql_fetch_assoc($products)); if(($rows = mysql_num_rows($products)) != 0) { mysql_data_seek($products, 0); // PROCEED TO THE NEXT CENTER $row_products = mysql_fetch_assoc($products); } ?> </select> </form> <br /> </td> </tr> <tr> <td valign="top"> <?php // IF ONLY ONE VARIABLE ADDED TO THE GET if($_GET['do'] <> "") {//THEN LIST THE DIFFERENT SELECTS AND SET THE NEW FORM ACTION ?> <form name="specs" id="specs" method="post" action="?do=loadTable&product=<?php echo $product; ?>"> <label for="form_factors">Form Factors:</label> </td> <td > <select name="form_factors" id="form_factors" onChange="javascript:document.specs.submit()"> <option value="">Select A Form Factor...</option> <?php do { echo '<option value="'.$row_fFactors['Form Factor'].'"'; // IF CURRENT FORM FACTOR EQUALS SELECTED_FORM FACTOR if(!(strcmp($row_fFactors['Form Factor'], $currentFormFactor))) echo 'selected="SELECTED">'.$row_fFactors['Form Factor']."</option>\n"; else echo '>'.$row_fFactors['Form Factor']."</option>\n"; }while($row_fFactors = mysql_fetch_assoc($fFactors)); $rows = mysql_num_rows($fFactors);// COUNT THE NUMBER OF ROWS if($rows != 0) //IF ROWS_IS GREATER THAN ZERO { mysql_data_seek($fFactors, 0); $row_fFactors = mysql_fetch_assoc($fFactors);// SET THE CURRENT RECORD TO THE NEXT RECORD } ?> </select> </td> <td valign="top"> <label for="graphic_proc">Graphic Processors:</label> </td> <td> <select name="graphic_proc" id="graphic_proc" onChange="javascript:document.specs.submit()"> <option value="">Select A Graphic Processor...</option> <?php do { echo '<option value="'.$row_gProcessors['Graphics Processor'].'"'; // IF CURRENT FORM FACTOR EQUALS SELECTED_ if(!(strcmp($row_gProcessors['Graphics Processor'], $currentGraphicProcessor))) echo 'selected="SELECTED">'.$row_gProcessors['Graphics Processor']."</option>\n"; else if($row_gProcessors['Graphics Processor'] != NULL) echo '>'.$row_gProcessors['Graphics Processor']."</option>\n"; }while($row_gProcessors = mysql_fetch_assoc($gProcessors)); // COUNT THE NUMBER OF ROWS_IN $rows = mysql_num_rows($gProcessors); if($rows != 0) //IF ROWS_IS GREATER THAN ZERO { mysql_data_seek($gProcessors, 0); $row_gProcessors = mysql_fetch_assoc($gProcessors); // SET THE CURRENT RECORD TO THE NEXT RECORD } ?> </select> </td> </tr> <tr> <td valign="top"> <label for="soft_support">Software Support:</label> </td><td> <select name="soft_support" id="soft_support" onChange="javascript:document.specs.submit()"> <option value="">Select A Software Support...</option> <?php do { echo '<option value="'.$row_softSupport['Software Support'].'"'; if(!(strcmp($row_softSupport['Software Support'], $currentSoftwareSupport))) echo 'selected="SELECTED">'.$row_softSupport['Software Support']."</option>\n"; else echo '>'.$row_softSupport['Software Support']."</option>\n"; }while($row_softSupport = mysql_fetch_assoc($softSupport)); $rows = mysql_num_rows($softSupport); // COUNT THE NUMBER OF ROWS if($rows > 0) //IF ROWS_IS GREATER THAN ZERO { mysql_data_seek($softSupport, 0); $row_softSupport = mysql_fetch_assoc($softSupport); // SET THE CURRENT RECORD TO THE NEXT RECORD } ?> </select> </td> <td valign="top"> <label for="ruggedization">Ruggedization:</label> </td> <td> <select name="ruggedization" id="ruggedization" onChange="javascript:document.specs.submit()"> <option value="">Select A Ruggedization...</option> <?php do { echo '<option value="'.$row_rugged['Ruggedization'].'"'; if(!(strcmp($row_rugged['Ruggedization'], $currentRuggedization))) echo 'selected="SELECTED">'.$row_rugged['Ruggedization']."</option>\n"; else echo '>'.$row_rugged['Ruggedization']."</option>\n"; }while($row_rugged = mysql_fetch_assoc($rugged)); $rows = mysql_num_rows($rugged); // COUNT THE NUMBER OF ROWS_IN RUGGEDIZATION if($rows != 0) //IF ROWS_IS GREATER THAN ZERO { mysql_data_seek($rugged, 0); $row_fFactors = mysql_fetch_assoc($rugged); // SET THE CURRENT RECORD TO THE NEXT RECORD } echo '</select>'; echo '</td>'; echo '</tr>'; echo '</table>'; echo '</form>'; if($tableResults) { echo '<br /><br />'; while($row = mysql_fetch_array($tableResults)) { // echo rows that match user information echo '<tr>'; print "\n"; echo '<td>'; print "\n"; echo $row['Product']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['Form Factor']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['Graphics Processor']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['InputsRGG']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['InputsNTSC']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['InputsLVDS']; print "\n"; echo '</td>'; print "\n"; echo '<td>'; print "\n"; echo $row['InputsDVI']; print "<br /><br />\n"; echo '</td>'; echo '</tr>'; } // END WHILE LOOP echo '</table>'; }// END IF RESULTS ?> </body> </html> <?php } ?> [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
