dropdown list populated with DB select

Hi

I have a issue with my php code which selects data from a mysql table and populates a dropdown.

There are 2 issues really:

  1. What would the php code look like which does a select from a table and presents it in the dropdown list
    (eg. First name) - I do not wish to have the values in the php code, it needs to be from a DB query.
  2. It should auto-populate another dropdown (eg. Family Name)

Some date and Comments needs to be added to the form before it is inserted/posted into the DB too.

Do I need a html form and php code?
What would this php and html code look like?

My php is not as good as my Mysql knowledge, please assist.

Sponsor our Newsletter | Privacy Policy | Terms of Service