How to populate drop down with values.

I want to populate values from a table into a dropdown allowing a user to select one and save it back to the database.

$db = &JFactory::getDbo();
$db->setQuery('SELECT * FROM tvs5y_custom_locations');
$locations = $db->loadAssocList();

var_dump($locations);

I've succesfully loaded an array and tested it with var_dump but am not sure what to do next.

Hi peterswa62,

Please see this FAQ

Bob

Dear Greyhead,

What is the new link to this FAQ item. Because I get an error 404. I am getting it by a lot of items bye the way.

Greetings Henny

Hi Henny,

Max has upgraded the site from Joomla! 1.5 to 3.2 and in the process many things changed and some broke - that includes all of the old FAQ URLs :-(

There's a plan in testing that will allow me to fix them if it doesn't break too many other things . . .

In the mean time your best way to access old faqs is to check the title from the URL on the old link: how-do-i-build-a-select-drop-down-radio-button-or-checkbox-group and put some of the key words in the Search box on the FAQ page. In this case 'build select' is enough and right now the FAQ is here.

Bob