Drop down menu values

[netfrugal]

I have a form below that shows a dropdown menu.
The values are email addresses populated by my SQL database, with their associated names placed between the option tags. (Don't ask why I'm using a SQL database - not my decision)

My dilemma:

I need to insert the $ManagerName into another database, while at the same time emailing them. I DO NOT want to insert the email address into the database.

Currently it won't work because only the value is entered into the database, and not what is showing in the selection list.

Any ideas on how I can perform this?

code:

<? //
$server="";
$username="";
$password="";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("ITSM",$sqlconnect);
$sqlquery="SELECT * FROM Manager;";
$results= mssql_query($sqlquery);
while ($row=mssql_fetch_array($results)){

$ManagerEmail = $row['ManagerEmail'];
$ManagerName = $row['ManagerName'];



$option_block .= "<option value=\"$ManagerEmail\">$ManagerName</option>";

} ?>

<? mssql_close($sqlconnect); ?>

<form id="form1" name="form1" method="post" action="sqlserver.php">
<select name="email">
<? echo $option_block; ?>
</select>
<label>
<input type="submit" name="Submit" value="Submit" />
</label>
</form>

[devinemke]

a few options:

#1 put the name and the email in the value tag separated with a pipe "|"

$option_block .= '<option value="' . $ManagerName . '|' . $ManagerEmail . '">' . $ManagerName . '</option>';

then in your form processing script use [man]explode[/man] to separate them

#2 simply requery the database for that email address in the form processing script

#3 store the query result in a [man]session[/man] and grab the email address from the session in the form processing script

[netfrugal]

the explode function sounds like a good idea, I will try that and report how I did!

Thanks Devinemke

[netfrugal]

Worked!

The explode function really helped out. Of course, for what I was doing I was required to create a few more variables to make this work for what I needed.

Here's the code I performed for testing it.

<?

$server="SQLSERVER";
$username="user";
$password="password";
$sqlconnect=mssql_connect($server, $username, $password);
$sqldb=mssql_select_db("DATABASE",$sqlconnect);
$sqlquery="SELECT * FROM Manager;";
$results= mssql_query($sqlquery);
while ($row=mssql_fetch_array($results)){

$ManagerEmail = $row['ManagerEmail'];
$ManagerName = $row['ManagerName'];

$option_block .= '<option value="' . $ManagerEmail . '|' . $ManagerName . '">' . $ManagerName . '</option>';

} ?>

<? mssql_close($sqlconnect); ?>

<form id="form1" name="form1" method="post" action="sqlserver.php">
<select name="NeededInfo">
<? echo $option_block; ?>
</select>
<label>
<input type="submit" name="Submit" value="Submit" />
</label>
</form>
<br />
<br />

<? // Explode
$separated = explode("|", $NeededInfo);
$email = $separated[0]; // email address
$Supervisor = $separated[1]; // name
?>
<? echo $email; ?> <br /><br />
<? echo $Supervisor; ?>