getting select value from loop

[markbm]

I am trying to get all the values from a mysql table...populate a drop down...select one of the values...and then pass that value via a form submit to the next page which processes the order_id to update a db row.....

The problem is that, regardless of which order_id I choose in the dropdown on page 1...the last value in the dropdown is always passed to page 2.

Any ideas? Thanks in advance.

Mark

Code section for page 1:

<?php
printf("<center><table width=260px border=1><tr bgcolor=#ededed align=center valign=center><td><b>HPG_PLAN_ID</b></td><td><b>DESIGNER_PLAN_ID</b></td></tr>");

       //while ( $row = mysql_fetch_array($result) ) { 
       while ( $row = mysql_fetch_array($result) ) { 
       	 $hpg_planid = ($row['HPG_PLAN_ID']);
         $designer_planid = ($row['DSGNR_PLAN_ID']);
         $designer = ($row['DESIGNER']);

         printf("<tr valign=center align=center><td><font face=Verdana, Arial, Helvetica, sans-serif size=2><a href='http://www.houseplangallery.com/index_files/prod_detail.php?planid=" . $row["HPG_PLAN_ID"]."&designer=$designer&price_code=$price_code'><font color=blue size=3><u>$hpg_planid</u></a></td><td>$designer_planid</font></td></tr>");
       	// printf("<tr valign=center align=center><td><font face=Verdana, Arial, Helvetica, sans-serif size=2>$hpg_planid</td><td>$designer_planid</font></td></tr>");

       };
       printf("</table></center>");
       ?>                       
        </td>

        <td>
      <center>   <img src="track.jpg" border=0> </center>

<center><table border=0>
<tr>
<td align=right valign=middle>

<?php printf("<form method=GET action=http://www.website.com/designers/db_insert.php>"); ?>
<?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>
</td>
</tr>
<tr>
<td align=right valign=middle>
<?php printf("<b><font face=Verdana, Arial, Helvetica, sans-serif size=3>Enter Tracking #:</b></font> </td><td align=left valign=middle><input type=text name=tracknum size=30 value=$tracknum></td></tr>"); ?>

<br>
<tr><td align=left valign=middle colspan=2>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<?php
printf("<input type=hidden name=d_id value=$d_id>");

printf("<input type=hidden name=order_id value=$order_id>");
?>
<INPUT type="submit" value="&nbsp;&nbsp;Submit&nbsp;&nbsp;">

</FORM>

CODE SECTION for page 2:

// process form

$date_insert = date("F j, Y, g:i a");

$stat = "IN PROGRESS - TRACK # UPDATED";

$query = "update orders set tracking_number='$tracknum', tracking_nbr_insertdate ='$date_insert', order_status='$stat' where order_id='$order_id'";

mysql_query($query);
echo "Record Updated<br><br>";
mysql_close();

[Weedpacket]

You're getting the value of order_id from the hidden field named order_id, which will contain the last value assigned to $order_id. Why is that value there, and isn't the one you want in $orders?

[markbm]

the order_id hidden field should have been commented out from previous testing.... i found my problem in that I was trying to insert $order_id instead of $order which was the select value...

thank you for pointing out that item....it helped very much...

Mark