Send only one value to DB

[aprinc]

In my form I have checkbox and select menu. Checkbox comes first in form. I would like to:

1) if checkbox is not checked and nothing is selected to give error message that user must choose something

2)if checkbox is checked and something is selected to store only checkbox value in DB

3)if something is selected in the menu to store that value in DB - this is not problem, just to avoid questions like what do I need select menu for

I know that IF should be used, just don't know how.
Thanks in advance.

[stolzyboy]

well you are kinda confusing yourself i think, you are making people check the box to get any further, but if they check the box and something else you only want the checkbox value inserted into database, then in line three you say if something is selected in the menu to input that into database, but they can't if they don't check the box, but if they don't check the box they get an error message.....

you see where i am getting at or am i confused also, maybe a little more information would help

[aprinc]

It's confusing 🙂
I'll try again.

1)ONLY if both checkbox and select menu are empty then error message

2)IF both checkbox is checked and something from select menu is selected STORE checkbox value in DB

3)IF only something is select from select menu STORE that value in DB

4)IF only checkbox is checked STORE that value in DB

I hope it's clear now 🙂

[stolzyboy]

this may get you in the right direction

<?
if ($_POST['nameofcheckboxinform'] == "" && $_POST['nameofselectinform'] == "")
{
//tell user to check something and spit out form again
}
else if ($_POST['nameofcheckboxinform'] != "" && $_POST['nameofselectinform'] != "")
{
//use insert statement to insert value of checkbox
}
else if ($_POST['nameofcheckboxinform'] == "" && $_POST['nameofselectinform'] != "")
{
//use insert statement to insert value of select menu
}
else if ($_POST['nameofcheckboxinform'] != "" && $_POST['nameofselectinform'] == "")
{
//use insert statement to insert value of checkbox
}
else
{
//spit out beginning form
}
?>

[aprinc]

OK, I tried to use first statement and I get error message that something must be chosen. But when I check checkbox or select something from select menu, I got same error message again that something must be chosen. What is wrong ? I use PHP3.

Here is first statement:

if ($POST['open'] == "" && $POST['start_year'] == ""){
print"<center><span class='main1'>Select YEAR in START DATE selection or check OPEN</span><br>";
print"<br><center><input type='button' value='Back' onclick='history.go(-1)'>";
}

[stolzyboy]

try using

$HTTP_POST_VARS['variable']

instead of

$_POST['variable']

or if register_globals is on you can just use

$variable

[aprinc]

Thanks a lot Stolzyboy, it works fine.