Retrieving database values in a drop down menu

I am creating a php mysql website which contains a submission form. I need a drop down menu in this form that will automatically select user id values from the users table in the database. The form will then submit the values to another table whose data can then be viewed on the site.

This is my users table : Create table users
username varchar(255) NOT NULL,
password varchar(255) NOT NULL,
first_name varchar(255) NOT NULL,
last_name varchar(255) NOT NULL,
email varchar(255) NOT NULL,
UNIQUE KEY username (username),
UNIQUE KEY email (email)


Can someone give me code for the form that will retrieve user id of registered users in the drop down menu. Thank you

What kind of start have you made on it? Can you show us your progress so far, so that we can assist you with it?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.