To create a drop down menu is easy, just use the codes I mentioned in my past post: HTML form element – Drop down menu.

But what if you want to have the data in the MySQL database to be the options of the drop down menu and the options are over 100 or more?? It is very time consuming to create all. But I am going to show you an easy way to do so which by creating a drop down menu involving with PHP and query. The codes are:

Editor’s note: To display the data from MySQL database with PHP, we have to use the mysql_query( ) function to run a SQL query, here is a sample I have made to display all data from a table with 2 fields.