Hi experts,
I am working with a table in a database (mysql) that keeps track of the users. The table fields are id, privilege (ie person's position in a committee -- a number mapping to a position name), username, and first and last name.
The privilege field is to be a scroll-down menu. I have created a simple one in HTML (let me know if you'd like me to post code), but then I realised that the selected item will not actually be sent to the database and hence the user will not actually be updated/added. There must be a way to keep track of data that has been entered about the user, I just can't think of it. I've been stuck for hours.
I've tried several versions of writing the menu in PHP (eg while loops, foreach loops..) but still get stuck on actually keeping track of user input.
Any help would be amazing.
Thanks in advance!!
-N
I am working with a table in a database (mysql) that keeps track of the users. The table fields are id, privilege (ie person's position in a committee -- a number mapping to a position name), username, and first and last name.
The privilege field is to be a scroll-down menu. I have created a simple one in HTML (let me know if you'd like me to post code), but then I realised that the selected item will not actually be sent to the database and hence the user will not actually be updated/added. There must be a way to keep track of data that has been entered about the user, I just can't think of it. I've been stuck for hours.
I've tried several versions of writing the menu in PHP (eg while loops, foreach loops..) but still get stuck on actually keeping track of user input.
Any help would be amazing.
Thanks in advance!!
-N
Comment