Thanks Pablo, I wound up with this...
<select size="1" name="customer"> <option value='none:none'>NONE</option> <?PHP while($query_data1=mysql_fetch_row($result1)){ echo"<option value='$query_data1[0]:$query_data1[1]'> $query_data1[1]</option>"; } ?> Then I simply do: $array = explode(":",$_POST['customer']); Then when I do the database update I just need to put $array[0], $array[1] into the fields in the database. Thanks, Jeff > -----Original Message----- > From: Pablo Gosse [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 13, 2003 3:27 PM > To: Jeff McKeon; [EMAIL PROTECTED] > Subject: RE: [PHP] Multiple values in a form option field > > > On Thursday, November 13, Jeff wrote: > > [snip]What I now need to do is store not only the userID but > the email address as well. Is there a way using a form to > store 2 values using one drop down box? So basically I want > to store the userID and the Email address to a variable in > the form so that both may be written to different fields in > the database later.[/snip] > > Hi Jeff. For this you'll need to use javascript and hidden > form fields. I've had to do this in a few places in my CMS > and it's not too difficult. > > The Javascript will be something like this: > > <script type="text/javascript"> > <!-- > // x is the select list in question > function setEmail(x) > { > var users = new Array(); > <?php > $count = 0; > foreach ($users as $id=>$user) > { > echo 'users['.$count.'] = '.$id.';'; > $count++; > } > ?> > > for (i=0;i<x.length;i++) > { > if (x.options[i].selected) hiddenidfield.value = > users[i]; > } > } > //--> > </script> > > One thing to make sure of is that you are looping through > your results in the same order both when you create the > javascript array inside the function, and also when creating > the select list. > > Then in your form have a hidden input as follows: > > <input type="hidden" name="id"> > > And for the select list, use the onchange attribute to set > the value of the hidden input field (onchange="setEmail(this);"). > > You'll obviously need to update hiddenidfield.value with the > proper reference to this input in the elements collection for > this form. > > I'm writing this off the top of my head, so if there are any > problems let me know. It should be pretty close though as I > had to do just what you asked a few times recently. > > Cheers, > Pablo > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php