when an employee registers they must be approved by a manager to have access to the login pages.
I have a table with a record called approved. It's initial value is 0. I want a query to show all that are 0. but at the same time i need to be able to click a checkbox to make the value 1. I need this to be a mass check box list.
Here is an idea of the SQL:
Select * from users where approved ='0'
i also want to be able to update the approved with a checkbox.
how possible is this for someone to give me a hand.
thanks