Creating Dynamic Drop Down List in PHP

Introduction

In this article I will explain creation of a Dynamic Drop Down List in PHP using a MySQL database. Such that, when you want to insert, delete or update data in our drop down list box, you directly insert, update or delete from the database. This phenomenon is called a dynamic drop down list. This drop down list dynamically fetches data from the database. This phenomenon I will describe here just with an example.

Example

In the following code, some car names are in my database and these car names are shown in our dropdown list dynamically.

<HTML>

<head>

<title>Dynamic Drop Down List</title>

</head>

<Body background="as.jpg">

<form id="form1" name="form1" method="post" action="<?php $_SERVER['PHP_SELF']?>">

Car Name:

<select name='NEW'>

<option value="">--- Select ---</option>

<?php

mysql_connect("localhost","root","");

mysql_select_db("vinod");

$select="vinod";