This time I have a question which might actually be intelligently phrased.
BACKGROUND:
I have a form which updates a single record in the database. On the form, there is a drop down list for 'quantity'. The current quantity database value (usually 1) is selected by default in the box.
When the user selects a new quantity, I want to multiply that value by the unit price to get a line total which will be updated to the database at the same time.
PROBLEM...
I don't know what to call the 'selected' value in my equation. Here is the code for the FORM in question. Could someone clue me in on how I'm supposed to retrieve this select value once chosen.
Code: Select all
<form name="update_cart" method="POST" action="<?php echo $editFormAction; ?>">
<table width="790" height="103" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF" id="cart_tbl">
<tr bgcolor="#990000">
<td width="92" height="30" align="center" valign="middle" bordercolor="#990000"><strong><font color="#FFFFFF" size="3" face="Arial, Helvetica, sans-serif">Part
Number</font></strong></td>
<td width="278" align="center" valign="middle" bordercolor="#990000"><strong><font color="#FFFFFF" size="3" face="Arial, Helvetica, sans-serif">Description</font></strong></td>
<td width="38" align="center" valign="middle" bordercolor="#990000"><strong><font color="#FFFFFF" size="3" face="Arial, Helvetica, sans-serif">Price
(Yen) </font></strong></td>
<td width="25" align="center" valign="middle" bordercolor="#990000" bgcolor="#33CC00"><strong><font color="#FFFFFF" size="4" face="Arial, Helvetica, sans-serif">QTY</font></strong></td>
<td width="79" align="center" valign="middle" bordercolor="#990000"><strong><font color="#FFFFFF" size="3" face="Arial, Helvetica, sans-serif">Total
(Yen) </font></strong></td>
<td align="center" valign="middle" bordercolor="#990000" bgcolor="#990000"> </td>
</tr>
<tr align="center" valign="middle">
<td width="92" height="71" bordercolor="#990000" bgcolor="#CCCCCC"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><?php echo $row_rs_cart_editї'cart_kb_prod_part_num']; ?> </font></td>
<td width="278" align="left" valign="middle" bordercolor="#990000"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><?php echo $row_rs_cart_editї'prod_e_desc']; ?> </font></td>
<td bordercolor="#990000" bgcolor="#CCCCCC"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif"><?php echo $row_rs_pluї'prod_sell_price_jpy']; ?></font></td>
<td width="25" bordercolor="#990000" bgcolor="#33CC00"> <center>
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif"></font>
<font color="#000000" size="2" face="Arial, Helvetica, sans-serif">
<select name="quantity_sel" size="1" id="select">
<option value="1" selected <?php if (!(strcmp(1, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>1</option>
<option value="2" <?php if (!(strcmp(2, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>2</option>
<option value="3" <?php if (!(strcmp(3, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>3</option>
<option value="4" <?php if (!(strcmp(4, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>4</option>
<option value="5" <?php if (!(strcmp(5, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>5</option>
<option value="6" <?php if (!(strcmp(6, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>6</option>
<option value="7" <?php if (!(strcmp(7, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>7</option>
<option value="8" <?php if (!(strcmp(8, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>8</option>
<option value="9" <?php if (!(strcmp(9, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>9</option>
<option value="10" <?php if (!(strcmp(10, $row_rs_cart_editї'cart_quantity']))) {echo "SELECTED";} ?>>10</option>
</select>
</font> </center></td>
<td bordercolor="#990000" bgcolor="#CCCCCC"> <center>
<font color="#009900" size="2" face="Arial, Helvetica, sans-serif"><strong><?php echo $row_rs_cart_editї'cart_line_total']; ?> <font color="#000000"> JPY</font></strong></font>
</center></td>
<td width="40" align="center" valign="middle" nowrap bordercolor="#990000" bgcolor="#FFFFFF">
<center>
<input name="cart_line_total" type="hidden" value="<?php echo ($row_rs_pluї'prod_sell_price_jpy'] * $select); ?>">
<input name="cart_id_num" type="hidden" value="<?php echo $row_rs_cart_editї'cart_id_num']; ?>">
<input name="Submit" type="image" value="Update Cart" src="../images/e_update_cart.gif" align= "middle" width="105" height="48">
</center></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="update_cart">
</form>Code: Select all
<input name="cart_line_total" type="hidden" value="<?php echo ($row_rs_pluї'prod_sell_price_jpy'] * $select); ?>">Any help greatly appreciated.
--------------------------------
SteedVLX