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

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

I have a parse error in this query help..
Code: $query1="INSERT INTO `rating` (`item_name`, `rating`, `ip_address`, `date_rated`) VALUES

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include