PHP Help

[SAFCliam91]

I have a database structure as follows,

 

 

Table structure for table staff

Column

Type

Null

Default

id

int(11)

No

 

username

varchar(100)

No

 

password

varchar(100)

No

 

email

varchar(100)

No

 

P1

enum('0','1')

No

 

P2

enum('0','1')

No

 

P3

enum('0','1')

No

 

P4

enum('0','1')

No

 

P5

enum('0','1')

No

 

 

 

P1 all to P5 are for different permissions, i need help creating a script that will list all the usernames off staff and checkboxes that can be ticked to allocate them to different permissions. (eg, p1 allows them to edit details on another page 1 been granted permission 0 meaning they don't have access)

 

can anyone help me with this please