Hi there!
I am trying to first populate a select box with an EventID and the EventTitle (but so the user just sees the EventTitle ). But then when they select an EventTitle and click the Submit ("Go") button, I want the form to populate with the details of the Event.
Therefore when they click the button, I want to be able to get the EventID from the Select box and use that to query the database to get the rest of the Event information...and then populate the rest of the form with it.
I don't know if I'm making sense, here is the page if seeing it will help:
http://www.5flavors.com/Event_update_form.php
Here is my code to populate the select box:
<SELECT value=" . $myrow['EventID'] . " name='aEventID[" . $myrow['EventID'] . "]'
ONCHANGE='pGoHere()'> ");
//echo "login_check = " . $login_check ;
if($login_check > 0) //If #3
{
printf("<option>");
//Fill Event Combo Box
while($myrow = mysql_fetch_array($vQueryResult_1))
{
$vEventID = $row['EventID'];
$vTitle = $row['Title'];
printf("<option>" . $myrow['Title'] );
}
}
What I want to know next, is how to get the EventID from the select box?? Or maybe the best question is how do I get the EventID into the Select box to begin with and then how do I get it out when the user clicks the Submit ("Go") button?
I'll use that EventID to query the database for the rest of that event's information.
Thank you! I hope this makes sense!!
