[Resolved] uncheck is not changing the value

phence

I know this has probably been asked before, but after seaching for about 30 minutes i got frusterated looking through all those checkbox threads...

here's my checkbox code:

<input name="show_first_name" type="checkbox" value="YES" <? if($usrVars['show_first_name'] == 'YES'){ echo " checked"; } ?>>

If the checkbox is checked it should send the DB a "YES" value
If it is not checked is shouldn't send the DB any Value...
That works, unless the user returns to the script and attempts to uncheck the box... that should send the DB no value, but instead it continues to send the "YES" Value...

How can i make it recongnize the the box has been unchecked???
Hope you all understand what i mean!
Thanks

bastien

Can i see the processing page where the data is validated and sent to the db? Its in here where it should be set...

phence

This here collects all the $POSTed Values...

foreach($_POST as $varname => $value)
		$usrVars[$varname] = $value;

phence

Other than collecting the POST's i do not do anything else with the checkmark variables... only the text fields do i have error checking and validating... other than those all i have is a simple SQL query...

What should i be doing?

bastien

show update statement

phence

$sql = "UPDATE users SET first_name = '$first', show_first_name = '$show_first', last_name = '$last', show_last_name = '$show_last', apt_num = '$apt', show_apt_num = '$show_apt', address1 = '$addy1', show_address1 = '$show_addy1', address2 = '$addy2', show_address2 = '$show_addy2', city = '$city', show_city = '$show_city', state = '$state', show_state = '$show_state', postalcode = '$pos', show_postalcode = '$show_pos', zip_ext = '$zip_ext', country = '$country', show_country = '$show_country', phone = '$phone', show_phone = '$show_phone', email = '$email', show_email = '$show_email' WHERE username = '$userid';";

bastien

The only thing I noticed was that the field names don't match:

In the form you have:

<input name="show_first_name" type="checkbox" value="YES"

In the update you have:

show_first_name = '$show_first',....

My guess is that they should match...ie the sql should be switched to:

show_first_name = '$show_first_name',....

phence

No, they are changed into simpler vars...

the insert into the DB works...
What i am lacking is the code to change the Value of the checkbox when it is unchecked after the user returns and decides he doesn't want it checked...

When the user first goes to the script, he checks the checkboxes he wants to... when he returns the same checkboxes are still checked, due to the data in the DB... Now if the user decides to uncheck a box or two the DB is suposed to be changed and updated for his next return... but unfortunatly as the script is now, it does not work... all the checks stay as they were for his first visit, not his update...

Thanks, hope that clears up my problem!
And thanks for helping!!

bastien

try

if ($show_first ==""){
   $show_first = Null;  //if you set the value to null
   $show_first = "No"; //if set to no
}

phence

well where at tho? which script?

phence

Hey Thanks for your Help, i figured it all out!!!

Thanks again!!!