For i and multiple variable selection

[Nico]

I've got a small query that fills in a drop down list with a first and last name, and that is the value I want for that drop down list only. However I would also like for a hidden value with the selected name's email address added to the form.

My select fill-in code is:

<select name=techname>
	$res = mysql_query("SELECT tech_last, tech_first, tech_email FROM $table2 ORDER BY tech_last")
		or die("Unable to pull Tech Information" . mysql_error());

		for($i = 0; $i < mysql_num_rows($res); $i++)
		{
		$temp = mysql_fetch_row($res);
		print("<option value=\"$temp[0], $temp[1]\">$temp[0], $temp[1]</option>\n");
		}
</select>

So I get the obvious list of people where the value is "lastname, firstname". I want to make it so whenever a name is selected it also takes the email address ($temp[2]) and correctly associates it with the selected name.

Do I need to make a seperate query to do this or is there some way to add it into the above code? How would I go about it either way?

Nico

[Nico]

well i came up with a solution, however I don't know if this would be considered good programming or not. Seems a bit messy to me.

$name = explode(", ", $techname);
$lastname = $name[0];
$firstname = $name[1];


$res = mysql_query("SELECT tech_email FROM $table2 WHERE tech_last='$lastname' AND tech_first='$firstname'")
	or die("Unable to pull Tech Info" . mysql_error());

	while ($row=mysql_fetch_row($res)) {
		$tech_email="$row[0]";		
	}

Any way to clean it up or does anyone have any other ideas on how I can get the info a different way?

Nico

[LordShryku]

Why not just set the value of the option to the email, and display the name as the choice?

echo "<option value=\"".$temp[2]."\">".$temp[0].", ".$temp[1]."</option>\n"; 

[Nico]

I need the $techname = 'firstname, lastname' and not the tech_email unfortnately. $ techname is put into a database and I need the $tech_email for an automated email.

Nico