user authentication by admin

[sirTemplar]

i have mysql database with username, passwords, etc. people can apply for membership via a form. after they successfully fill up the form they are added to the database. what i want now is this.

1) that their account remain inactive unless admin activates the account.

2) a login script where only ACTIVE members are successfully redirected to main page and other secured pages.

any help how i should start? thanks.

[vaaaska]

Your question is pretty open ended, but I'll take a jab at this.

Why don't you create an extra field and call it something like 'confirm'. It would simply hold a 1 or 0 and the admin would need to change the value to 1 when it was approved.

Then in all of your authentication scripts just add something to your query...

AND confirm='1'

If it isn't 1 they will get the unauthorized stuff still...

Good luck...v