Editor’s note: To create a MySQL database table with PHP is very straight forward, all you have to do is to know the query for creating the MySQL database table, and use PHP function mysql_query( ) to run that query. You could also use a HTML form to let the user to input the name of the table.

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.

Editor’s note: In this post, I would like to show you how to use PHP to connect to a MySQL database. It is very a important part in the PHP and MySQL programming.