New Select box back to clear?

[Chrisjc]

Now that I have a full version of drop downs with my database working be-side it using PHP and AJAX... I have a new question.... That question is Say a user picks first dropdown = GAS then they pick 2nd dropdown= FORD then lets say they pick everything else and they get the part number but oh wait they didnt mean to PICK FORD.... so they go back to that dropdown box and change it to GMC... but the other boxes didnt go back to ( SELECT ) only the one under it.... is it possiable to clear them all back to SELECT???

link ( www.triplesource.net/db/v5/ )

Thanks in Advanved

Chris

[ronverdonk]

With Javascript you can delete dropdown entries, starting at the next one from the DIV you are going to fill. This can be done via the DOM.

Ronald :cool:

[Chrisjc]

With Javascript you can delete dropdown entries, starting at the next one from the DIV you are going to fill. This can be done via the DOM.

Ronald :cool:

I dont fully under stand...

I also came across a new issue I sent you a E-mail about it also here is what I sent you.

Okay new problem found....

In this area of CODE
================================================== =======

 // ================================================================================
// Get the EXPPARTNO after user selected fuel, make, model, year, engtype and liter and display EXPPARTNO
// ================================================================================
if(isset($_GET['getpart']) AND isset($_GET['fuel']) AND isset($_GET['make']) AND isset($_GET['year']) AND isset($_GET['model']) AND isset($_GET['engtype']) AND isset($_GET['liter'])){   
  $fu = $_GET['fuel']; 
  $mk = $_GET['make']; 
  $yr = $_GET['year'];
  $mo = $_GET['model'];
  $en = $_GET['engtype'];
  $lt = $_GET['liter'];
  $res = mysql_query("SELECT exppartno, expldescr, dciptdescr FROM Catalog WHERE fuel='$fu' AND year='$yr' AND make='$mk' AND model='$mo' AND engtype='$en' AND liter='$lt' GROUP BY exppartno, expldescr, dciptdescr ORDER BY exppartno, expldescr, dciptdescr")
     or die("Invalid query: " . mysql_query());
  if (mysql_num_rows($res) > 0) {
    while ($row = mysql_fetch_assoc($res)) {
      $pn = $row['exppartno'];
      $ed = $row['expldescr'];
      $dc = $row['dciptdescr'];
      echo "<label><b>Part number:</b></label>$pn ";
      echo "<p>&nbsp;</p>";
      echo "<b>Description:</b>$ed, $dc";
    }
  }
   else {
    echo '<label>Part number:</label>Not available <b>Description:</b>Not available<br />';
  }
} 
?>

================================================== =======
Yeah it pulls what it needs but.... If you pick from the following fields please... ( DIESEL) (CHEVY) (SILVERADO 2500 HD) (2001) (V8) (6.6) It will show one part number..... HOW EVER in the DATABASE there is well over 5 items... it should be showing.... and is not... Now if I take the GROUP BY and ORDER BY statment out... it will show just EXHUAST part NUMBERS with it on it shows the AIR FILTER....... Why is this???? How do I make it show all??? By the way I added another ROW in the database... in this ending statment... IT IS (DCIPTDESCR) And I was trying to get everything to be displayed on one line... and then show everything else down... so like this

PART# 54-1000 Description: Air Filter, OE etc....
PART# 54-1002 Description: Air Filter, OE etc.....
and so on whatever there is to list that matchs... and I know for this selection there shold be at least 5 or more.... I looked them up in my DB in EXEL...

Let me know what you find Thanks in advanced!

[ronverdonk]

Remember that your DIV6 height (in INDEX1.PHP) is defined as 30px, so it can contain only 2 lines of text!. Make it 300px and see the difference.

Ronald :cool:

[Chrisjc]

Remember that your DIV6 height (in INDEX1.PHP) is defined as 30px, so it can contain only 2 lines of text!. Make it 300px and see the difference.

Ronald :cool:

Ahhh I c thank you thank you!!

Most helpful!!!

Okay now the biggest question I have of all... When you selecting and someone messes up... how do I get it to clear? back to SELECT??/ what is DOM???

[ronverdonk]

The DOM (Document Object Model) gives you generic access to most elements, their styles and attributes in a document. This is a no-nonsense, easy to follow DOM reference for JavaScript.

You can reach each part of an HTML document via the DOM, so you can also reach the DIVs that are used to be filled with the selection results.

The user doesn't mess up, it is normal user behavior to browse his options.
E.g. you have 6 DIVs to fill. When the user suddenly starts to select the content of DIV3, you supply the result in the usual way PLUS the code to clear DIVs 4, 5 and 6 (that is done via the DOM) via Ajax.

Ronald :cool: