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

function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha

How to have a log of all the status a VIM document had been ?
Hi guys,

I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transa

Limiting checkboxes?
Hi guys,

I have this code: Code: if(isset($_POST['selected'])) {
foreach($_POST['selec

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

getting a website's source code as a variable? How?
Hey guys, is there any way for me to get the source code of a website as a variable for me to work w

Fetching array then reversing it
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar

SESSION question
I am building an application , a directory for auctions.
For SEO i made a script which copies a p

Will an XHTML DOCTYPE interfere with my PHP if I'm not experienced enough?
I've read this article here: http://friendlybit.com/html/why-xhtml-is-a-bad-idea/

In a nutshe

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