checkbox update

Posted on 16th Feb 2014 07:03 pm by admin

I am having a brain fart right now and i cant remember how to do this. if anyone could help that would be great. I have search google and this forum but have not found what i am looking for.

thanks

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 then need to to display all the rows and fields for each user where the approved is '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

Your Answer:

Login to answer

Other forums

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

How to get exact 3 moths post date from today date using javascript
How to get exact 3 moths post date from today date using javascript
Please help

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

Executing an exe
Hi. I have some bizarre problem with exec (other any other method) to launch exe's. I am making a ga

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

Please help with code for SMTP authenticated PHP email form
Hello, I'm creating a PHP email form, and for this particular server, I have to use SMTP Authenticat

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l