Is it possible to create a bound column like in MS Access

[php_beginner_83]

Hi All

On my webpage I want to use a pull down menu. This menu I want to be populated with values from a table in my mysql database. However, what I want to do is have my pull down menu have a bound column like in Microsoft Access. So for example, say I have two sets of values from the table in my database, ID and NAME. In my pull down menu, I want to display the NAME values but actually want to use the ID value associated with the NAME value. It's the ID value I need but if I display this in the pull down menu, the user will have no clue what it means.
Does anyone have any suggestions or advice about how this can be done??

Thank you.

[CoderDan]

something like this?:

<?php
$query = "SELECT id, name FROM table ";
$result = mysql_query( $query ) or trigger_error( mysql_error(), E_USER_ERROR ) );
$options = array();
while ( $option = mysql_fetch_assoc( $result ) )
{
	$options[] = "<option value='$option[id]'>".htmlentities( $option['name'] )."</option>";
}
echo "<select>".join( '', $options )."</select>\n";
?>