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
( id
int(11) NOT NULL AUTO_INCREMENT,
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,
PRIMARY KEY (id
),
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