PHP and values of drop-down lists

Anon

Hey all,

                     I initially set out to have the current date injected into the 'dateassinged' text box when a user was selected from the drop-down menu.
                     I've succesfully acomplished that with the Onchange event; now the problem is that when the page gets submitted to the database the
                     date value in the select gets injected instead of the name. Any ideas on how to inject the name (ex. Eddie Kendrick) instead of the date
                     value ? 

                     thanks in advance, I'm really lost on this one 

                     -Honky 




                     <form name="theform"> 
                     <select name='assignedto'onchange="theform.dateassinged.value = theform.assignedto[theform.assignedto.selectedIndex].value"
                     size='1'> 

                     <option selected><?php echo $assignedto ?></option> 
                     <option value="<?php print date("y-m-d"); ?>">Sondra Coatta </option> 
                     <option value="<?php print date("y-m-d"); ?>">Eddie Kendrick </option> 
                     <option value="<?php print date("y-m-d"); ?>">Steve Mills </option> 

                     </select> 

                     <input type='text' name='dateassinged' value='<?php echo $dateassinged ?>' size='20'> 

                     </form>

stevo

Hi,

the reason the date value gets injected, is that it is in the value perameter of the option,- the name is only a text label for the value.
(unless i have misunderstood what you are trying to do)

cheers,
steve

Anon

How can I pass the users choices/selection to MySQL?

Here is a sample of the code:<td rowspan="2" bgcolor="#F6E6AC" nowrap width="158" height="244"> 
 
 
         
<select name=PICK63 tabindex=9 onchange=PickSelected(63); size=1><option class=NoPickMade selected>----
No Pick ----<option class=NoPickMade><option class=NoPickMade></option></select>
</td>
<td rowspan="2" bgcolor="#F6E6AC" nowrap width="158" height="244">  

<select name=PICK62 tabindex=8 onchange=PickSelected(62); size=1><option class=NoPickMade selected>----
No Pick ----<option value="36">Florida<option value="50">N. Carolina</option></select>

  </p>

<p>&nbsp;<font size="1" face="Arial" color="#000000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></p>

</td>
<td rowspan="1" bgcolor="#F2F2DB" nowrap width="159" height="224"> (5) Florida (24-7)
 (8) N. Carolina (18-13)
</td>
<td align="Center" rowspan="1" bgcolor="#F6E6AC" nowrap width="8" height="224">