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

Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

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

single page with referrer to show correct page
I have a simple website with a couple of different pages. I would like to be able to in a div tag w

Multiple includes losing variables
Hey all,

just starting out w php and ran into a problem pretty quickly. I'm
including seve

Printing a webpage
I use this to print the webpage: o

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

PHP Redirecting
Hello everyone. Is there a way to redirect people to pages within a statement in PHP? Since there is

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde