VIP Forum Help

[DJCMBear]

I need help on sorting out a php/HTML file for a admin add a VIP member page for me as the admin I already made the code for a drop down menu that shows up all the usernames in the mysql table, I need to be able to select one of the users and with a second drop down menu select yes or no and then click go and that will change the number under the VIP column in the mysql user table but I cant seem to get the user and the yes/no that I selected to do anything and change the number in the table, what I want to be able to do.

 

for example: If I select the username bob in the first dropdown menu and change the second dropdown menu to yes it will find where the user bob is in the table and change the 0 to 1 under the VIP column and if I go back to the page and select bob again but this time change the second dropdown menu to no it will change the 1 back to a 0.

 

So Mysql table would look like this before the change:

Username

VIP

Bob

0

 

And the table will look like this after the change:

Username

VIP

Bob

1

 

And the other way around if its set to no.

 

Attachment is an image of the layout i have done.

 

If anyone can help please reply thanks

 

[attachment deleted by admin]

[trq]

Where exactly are you stuck?

[DJCMBear]

i have done the layout such as the 2 dropdowns and the submit button which i have done the code for the first dropdown which shows the usernames from the mysql table but i dont know how to get whats selected in the two menus and send it to the mysql table to change the number in the VIP column

[trq]

Theres a book in my signiture (Hudzilla), within that there are chapters on using forms and databases within php. Have a read of that and get back to us if your still stuck.

[DJCMBear]

Thanks for the help for now and im sure ill be back if there is still a problem as this is a very helpfull forum.