[support] creating drop down menu on a page

Hi,

I am having problems setting up a drop down menu on a page.

The page content is PHP.

I would like to have a drop down menu with a few fields (ie name/date/size) that people can choose from. This selection would then be stored as DROP_DOWN_FIELD below.

<?php $result = db_query("SELECT * FROM {fruits} ORDER BY $DROP_DOWN_FIELD DESC"); while ($row = db_fetch_object($result)) { $fields = array(); // define empty array array_push($fields,$row); // push row object onto the array print_r($row); */ ?>

Can anyone provide any help?? I have been trying for ages without any luck.

Paul