Jump to content

AV1611

Members
  • Content count

    997
  • Joined

  • Last visited

Community Reputation

0 Neutral

About AV1611

  • Rank
    Prolific Member
  • Birthday 03/03/1965

Profile Information

  • Gender
    Not Telling
  1. AV1611

    Dynamic Pulldown

    Thank you. Unfortunately the tutorial doesn't answer my question. 1. I don't know AJAX 2. While I know many disagree, I don't need to use jQuery, and have no idea how to use it. Please let's don't argue about that. 3. When I fill in the initial < input type = text > I assume I need to do onChange = myFunction() 4. so I really need to know how to write myFunction. I can write the PHP script that gets queried by myFunction. Your tutorial, aside from using Jquery which I don't really understand, drives a pulldown from another pulldown , I think... I am 6 months into this project, and don't really want to change to jQuery at this point.
  2. AV1611

    Dynamic Pulldown

    Ok, I have NEVER tried to use AJAX before. I have a web application that requires the user to select an item from a pulldown. The first input is a Lot number. The info to build the select list is generated via an MySQL query. Now, here's the thing. There are MANY items in the pulldown (1,000) which is not practical. I would like to run a query modified by the string they put in the first input box. I'm trying to avoid a page reload. So, Here is the input box <input name="lotno" /> Here is the basic pulldown code: echo "<option value='void'>--- Select a test ---</option>"; $sql='SELECT distinct `test_templates`.`tempid`, concat(`test_templates`.`assy`," - ",`test_templates`.`testdesc`) as Description FROM `test_templates` ORDER BY `assy` ASC'; $result = mysql_query($sql); while($row=mysql_fetch_array($result)){ echo "<option value='".$row[0]."'>"; echo $row[1]; echo "</option>"; } } I would change the above SQL with ...WHERE `lot` like WHATEVER IS IN THE lotno input field. Then the result of the query would be very limited. Thanks in adanced.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.