Form drop down boxes

mysql_query

Hello. I need a code (or part of a code) that makes a drop down box of a field I have in a MySQL database. I need that field to appear from all the rows in my table.

I have a table called 'roster' and I need the field 'name' (it's value) to appear in the drop-down box.

Any help is appreciated.

Thanks

greg252

How big of a menu are you writing?
I am now a big fan of dynamic menus from text files insead of utilizing a DB to manage < 50 data item.

Read the text file into a string, explode by the delimiter, and loop through the resulting array with each member echoed with <option>

mysql_query

My menu, huh?

It can be from 1 to infinity.

When a new member signs-up, his name gets added to that list.

Hope this helps you help me.

greg252

If you are dealing with a HUGE (infinite) number of results from a query, may I suggest the following:
Instead of dropping down an infinite (select * from table) number of results, do a small search on the db to limit the results. I.e. I am looking for client <input type = text name =search>

Now, do a search on the db with a LIKE statement to norrow the number of members of the drop down.

With the result set of the search, build the menu with
select * from table where field LIKE '$search'
or LIKE '%search%' if you'd like.

while/list through the result with echo "<option>$var";