Beast27

The tables in my SQL (college) are already populated. I have manually inserted those values. I want all the "name" fields from SQL (college) to appear as OPTIONS for a select box(alphabetically). The concept of the page as a whole is like this. There will be a list box titled "college" and the user will be able to select one of the colleges from this list box. Thats all there is to it. I am guessing I need to call a query such as: SELECT name FROM college ORDER BY name ASC Then i would have to put those values as options in my listbox. This is the code for my listbox <select name="college"> <option>college 1<.option> <option>college 2<.option> <option>college 3<.option> <option>college 4<.option> etc...all the way till the LAST college in my SQL (college) table. Im sorry for the confusion but if you have any more questions i will clarify them.

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none." I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you. [attachment deleted by admin]