3 Responses to “How To Code A Simple Php Dynamic Dropdown Form Feild From Mysql?”

1. robert_o Says:
   July 6th, 2009 at 11:28 pm

   Contact me and I will send you some sample code

2. Peter K Says:
   July 6th, 2009 at 11:28 pm

   You have a normal drop down option box, and for each line to insert the fields returned from your query.
   When you say dynamic, you won’t be able to do more fetches after the page has loaded. You only get one chance to do the PHP.

3. xArz Says:
   July 6th, 2009 at 11:28 pm

   Here’s my code:
   < ?php
   //please replace the variable with its respective values
   //$host for the mysql host name
   //$username for the mysql user name
   //$password for the mysql password
   mysql_connect($host,$username,$passwo...
   //$dbname for the database name
   mysql_select_db($dbname);
   ?>

   < ?php
   $query = "SELECT * FROM country";
   $result=mysql_query($query);
   while($row=mysql_fetch_array($result)...
   echo'
   ‘;
   }
   ?>
   

   So what Im doing in my code is first connect to the database and select which database im going to use. And then on the second part of the php im retrieving the ‘name’ field from ‘Country’ table and print it.

   Leave a Reply

   Name (required)

   Mail (will not be published) (required)

   Website