I am creating a basic form that posts data to a mySQL database. One of my tables, called "sites", contains the following information: site_name, site_id. I have created a dynamic dropdown menu of the sites (so the dropdown menu references the table "sites" to display all site names in a dropdown list). Based on the site_name selection, I would like the site_id to automatically populate the next text box in my form. **Here's the catch. I do not want to use any java or ajax. ** Please excuse the messy code, I deleted a lot of the private information. Thank you for your help in advance.


<form action="mait.php" method="post">

Site Name:  

        mysql_connect("localhost", "root", "") or die(mysql_error());
        mysql_select_db("database1") or die(mysql_error());

        $sql = "SELECT site_name FROM sites ORDER BY site_name";

        echo "<SELECT name='mait_site'>";

        $result = mysql_query($sql);

        while ($row = mysql_fetch_assoc($result)) {

        echo '<option value="'.$row["site_name"].'">'

        echo "</SELECT>";

Site ID:
    <<<<<neeed this field automatically populated based on Site Name selection>>>>>

3 Years
Discussion Span
Last Post by iamthwee

If you don't want to use ajax then as you select an option and then form submit it will have to go to another page or something like that.

I would say opting to NOT use jquery is a daft idea as every browser should have it enabled and it is dead simple vis a vis:


Edited by iamthwee


Thanks for the response. As long as jquery is a universal function, I will give it a shot. I see that your example is simply pulling the fill in options from the code. Does jquery have the ability to grab that supplemental information from a MySQL table?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.