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

No comments posted yet

Your Answer:

Login to answer
106 Like 8 Dislike
Previous forums Next forums
Other forums

PHP Include w/If IE Condition Statement?
I was having a problem with Internet Exploder (big surprise, right?) displaying my drop down menus i

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

New to PHP and just trying to understand a little code.
I hope I'm not annoying anyone or breaking the rules but I was wondering about this bit of code righ

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

Function module "DPS_CHECK_TABLE_EXISTS" not found (after OSS 1422843 impl)
Dear All,

I implemented Note OSS 1422843.

When i execute the new report RSPO20

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

Any decent php formatter/beautifier/pretty printer?
Any decent php formatter/beautifier/pretty printer class/function?

I found the following whil

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Dynamically allocating the number of rows in a table based on a variable value
Hi,
I have situation here which i cannot resolve, I have a variable temp which stores the num

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash