get and pass select values from dynamically created drop down

markbm

I am trying to query the database for all orders, for a given designer, populate these orders in drop down, and then let the designer select one of the values in the drop down to add a tracking number.

The part that I cannot get to work is when the form is submitted, it always passes the last value that was populated in the select box, regardless of what is actually selected...

Any ideas would be greatly appreciated. Thanks.

Mark

Code:

<?php printf("<form method=GET action=http://www.website.com/designers/db_insert.php>");

    //determine designers orders by looking for their id


// execute SQL query and get result
$sql_result = mysql_query("SELECT * FROM orders where designer_id = '$d_id'", $db);

// put data into drop-down list box
while ($row = mysql_fetch_array($sql_result)) {

$order_id  = $row["order_id"];
$option_block .= "<OPTION value=\"$order_id\">$order_id</OPTION>";

};

<b><font face=Verdana, Arial, Helvetica, sans-serif size=3>Order Number:</b></font>
</td>
<td align=left valign=middle>
<SELECT name="orders">

<?php echo "$option_block"; ?>

</SELECT><BR>

Elena_Mitovska

I tried your script and everything worked fine
I just added to your code these lines in order to submit a form and see the value passed:

Note:Form is submitted in the same file (in my case - test.php)

<?
echo "Submitted value:".$orders;

<b><font face=Verdana, Arial, Helvetica, sans-serif size=3>Order Number:</b></font>
<form name="testForm" action="test.php">
<SELECT name="orders">

<?php echo "$option_block"; ?>

</SELECT><BR>
<input type="submit" value="Send">
</form>

Scurvy

Hi all,
I tried this script and it works fine for me as well. One question though, is it possible to have the data submitted without using a submit button? Like an OnClick java type thing where you just select the option you want and it goes through?
Thanks,
Scurvy

Elena_Mitovska

You can hang OnClick event on any element you wish, image, link and etc, then in javascript for this OnClick event specify :

document.myForm.submit();

And it wil submit your form and its data.

another way to submit data is explicit: other_php_file.php?data1=value1&data2=value2.... and etc. If you have only few values to submit, this way may see quite appropriate, but if you have a lot of values to pass, obviously better to use Form.

If somebody knows some other ways to submit data except those two above, I would like to know 🙂

Scurvy

Thanks Elena. One more question though. I'd like to use this for a couple of drop-downs on the same page. 4 in fact. Each would query the same database and table but for different data.
List 1 would search 'WHERE city=$city"
List 2 "WHERE name="$name"
etc.
When I try this as is, each drop down lists the previous list plus the new one so list 2 has cities then names.
City:
Daytona Beach
Orlando
New York

Name:
Daytona Beach
Orlando
New York
Jason
Jeff
Sara

Any ideas how to make this work?
Thanks

Elena_Mitovska

Please, let me see the script you use to fill up drop-downs on your page

Scurvy

Well, it's the same as the above except for the table and fields:

<?php 

include('connect.inc');

printf("<form method=GET action=cityview1.php>"); 
//determine designers orders by looking for their id 

// execute SQL query and get result 
$sql_result2 = mysql_query("SELECT DISTINCT(city1) FROM doctors", $db); 


// put data into drop-down list box 
while ($row = mysql_fetch_array($sql_result2)) { 

$city1 = $row["city1"]; 
$option_block .= "<OPTION value=\"$city1\">$city1</OPTION>"; 
}; 

?> 
<SELECT name="city1"> 

<?php echo "$option_block"; ?> 

</SELECT><BR>

<input type="submit" value="Find City"></form>

Then I just put the same thing in a different table cell but changed all references to $city1 to $doctor.