Multi Column Select Help

[mellis95]

I am not sure where is the right place for this, but here it goes. I have a select list that pulls data from mysql table (code below). I need to pass "specialty_id" as a variable, but I need "specialty" as a descriptive field in the list for the user to pick from. When I use this as below, it passes both "specialty_id" and "specialty" as the variable. How to I make it show both but only pass "specialty_id" as the variable?

 

CODE:

 

echo '<select name="q" STYLE="width: 300px">' ;

$res=mysql_query("select specialty_id, specialty from tbl_specialty where specialty_id < 7 ORDER BY specialty");

if(mysql_num_rows($res)==0) echo "there is no data in table..";

else

for($i=0;$i<mysql_num_rows($res);$i++) {

$row=mysql_fetch_assoc($res);

echo"<option>$row[specialty_id] $row[specialty]</option>";

}

echo'</select>';

?>

 

Thank you in advance for the help.

[RussellReal]

echo "<option value='{$row['specialty_id']}'>{$row['specialty']}</option>";

[mellis95]

That works. I really appreciate the help.