Listbox

[Geno]

Hello,

I have 2 listbox.
The first one is the list of users that cant have acces to a page and the second one is user that can have acces to the page. What I want to do is

Cant Can
--------- ---------
|User#1| >>> |User#3|
|User#2| <<< |User#4|
--------- ---------

So when you click on <<< or >>> it adds the user youve selected in the different mysql table. With some javascript code, users would move between the 2 boxes.

I would like to know how you can do that ?

Thanks !

[ober0330]

Moving them between the boxes is a javascript problem, and I suggest you post there to do that part if you don't know how.

Moving them from one table to another is not the most efficient way to achieve what you are trying to do with mysql. A better way would be to use an extra field in the table that is either a 1 or a 0. Then simply update that field depending on what box they are in when you submit the form.