help with activation/script
I have a members area, where users sign up using register.php, which then emails us to activate them. We will then log into our admin panel to activate any users not yet activated. Each user will only be allowed specific access to certain areas of the site i.e. if they own 2 products out of four they can only access support pages relating to those products. The access levels will be set when we activate the user. (have i lost you yet?)
I have the majority of scripts working, the only bit i'm stumped with is the activation. Ideally, i'd like to retrieve all users from mysql db with the field activated=0 (so not activated) into a table, which i can do and have got set up. Then....
This is where i get lost: i want to make a form for each user retrieved into the table above, with checkboxes for each area i want to allow them to, all within the same table and once submitted will activate each user at a time.
Any ideas on the script? I can supply what i have now if needed?