Form field data pulled from database

[eluser]mdcode[/eluser]
Admittedly it's early in the day and I've only had one coffee, either that or I'm just dense, but I don't entirely get what you're asking me here. The foreach loop is to loop through the results and have them ready to be placed in the drop down; if I echo them, sure I get the results but they are just echoed at the top of the page - it delivers, just incorrectly.

I would be interested in how to modify the view in such a way though.

I have just tried Fuzzy's method and it almost works. When the drop down is active, the results display like this:

Code:

0 --- Displayed as an optgroup
1
Company 1
1 --- Displayed as an optgroup
2
Company 2

Basically, I only want only the name of the company to appear in the list (there will potentially be about 50 companies in this list) and when inputting the project into the database, the id of the selected company will get inserted into the project row.