Drop Down Menu and Mysql

[Mickie D]

i have these codes but they are not quite working, can somene take a quick look please

PHP Code:


// ##### drop down cleaning ##### 
$vbulletin->input->clean_gpc('r', 'dropdown', TYPE_NOHTML);

// ##### dropdown variable #####
$dropdown = $vbulletin->GPC['dropdown'];


if ($dropdown == rh){
$vbulletin->db->query_read("SELECT rh23 AS $code23, rh24 AS $code24, rh25 AS $code35, rh26 AS $code26, rh27 AS $code27 FROM " . TABLE_PREFIX . "viewing");

} 


and when i try and display it it shows nothing in my form

SNIPIT OF FORM

PHP Code:

<tr><td align="right">number 23 :</td><td><input type="Text" name="Code23" size="4" value="$code23" maxlength="4"></td></tr>
<tr><td align="right">number 24 :</td><td><input type="Text" name="Code24" size="10" value="$code24" maxlength="9"></td></tr> 


thanks very much