html - php populate option box from database table -

I am writing code to register a new project through an html form. I want to be able to click on a dropdown box that removes the value from the table on the database. I

At the moment a dropdown box is displayed but there is no value.

Please note: I apologize if this is a simple question / answer scenario.

>

My code is below, any help is appreciated, I connected to the database through a php script included. The table is called 'Customer' and the item I want to go to the list is 'name'; -

  & lt; Php $ result = mysql_query ("select customers by name"); Echo "& lt; select name = 'customer' & gt;"; While ($ line = mysql_fetch_assoc ($ result)) {echo "option" = "". $ Line [name]. "'& Gt;" $ Line [name] ". & Lt; / option & gt;"; } Resonate "& lt; / select & gt;"; ? & Gt;  

"The table is called the 'customer' and item that I want to see in the list, instead of 'name' ; " -

customer name < Code> Select Customers by name

• Use mysql_query () to mysql_query () The table name is not present.

Plus,
[name] citations are unavailable inside them => ['name'] < / Code> which is being considered.

  echo "  
 and  devdesign  
 
  echo option option = '". $ Line ['name']. '' & Gt; " $ Line [. ' Name ']. "& Lt; / option & gt;";  
 
 However, you are using a deprecated MySQL library. If you are still not getting the results, then this may mean that you need to use  mysqli _  or PDO instead. 
 
 Here are some links to this topic: