JavaScript - Form Drop Down List

[TBird2424]

Hello, I am new to JavaScript and I am trying to develop a tool for my wife's work. Right now I am trying to figure out how to get all the users in a data base to show up in a drop down selection box in a form. This way if any new users are added between visits to the webpage the new users will be automatically added to the list.

Anyone have any direction for me to go or know where I mgiht find some help for this.

Thanks in advance.

Jeff Moore(TBird2424)

[QuietDean]

Hi there,

Heres an example I found:

<?php



function generate_box() {

    $sql = "SELECT * FROM xxxx";

    $result = mysql_query($sql);

    $entries = mysql_num_rows($result);



    for($n = 0; $n <= $entries; $n++) {

        $sql = "SELECT * FROM xxxx WHERE ID = $n";

        $result = mysql_query($sql);

        while ($info = mysql_fetch_array($result)) {

            foreach( $info AS $key => $val ) {

                $$key = stripslashes( $val );

            }

            $options .= "<option value=\"-1\">$name</option>";

            $options .= "<option value=\"-1\"></option>";

          }

    }

    return $options;

}



$options = generate_box();



?>

<form method="get" name="forum_select" action="search.php"><table cellspacing="0" cellpadding="0" border="0">

	<tr>

                <td><span>Search By: 

<select name="by">

<? echo "$options"; ?>

<input type="submit" value="go"></span></td>

	</tr>

</table></form>

[TBird2424]

Quiet Dean, I am a little confused here. Is this PHP code or JavaScript? What is the difference? Sorry but I am truely a Nooby on JavaScript and still learning the many different types of code.

[QuietDean]

Hiya,

Its actually PHP. My bad, I paid no attention to where you had posted.

You cannot access a database using only JavaScript, unfortunately. But you can by using a server-side language like PHP. If you are on a windows server, you may be better off using ASP or ASP.net.

[TBird2424]

Thanks for the reply. At least that gives me a direction to go now.

Thanks for your help again.