Whats wrong with my query?

Posted on 16th Feb 2014 07:03 pm by admin

I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are ticked then I want it to display all vehicle roof heights. However it doesn't work correctly, for example if i tick the Standard roof Height checkbox then submit the form and echo the $RoofHeight to the page I get:

Code: N/A', 'Standard Roof', 'Medium Roof', 'High Roof
The same goes if I check the medium or high roof buttons.

If I tick the N/A button then it just returns "N/A", so why does it work for 1 tickbox but not the others?

Here is my PHP code;


Code: //display all roof height vehicles when submit button isnt pressed
if (!isset($_POST['N/ARoofHeight']) && (!$_POST['Standard Roof']) && (!$_POST['Medium Roof']) && (!$_POST['High Roof'])) {
$RoofHeight = "N/A', 'Standard Roof', 'Medium Roof', 'High Roof";
}





//N/A Roof Height Only
if (isset($_POST['Submit']) && isset($_POST['N/ARoofHeight'])) {
$RoofHeight = $RoofHeight."N/A";
}



//Standard Roof Only
if (isset($_POST['Submit']) && isset($_POST['Standard Roof'])) {
$RoofHeight = $RoofHeight."Standard Roof";
}

//Medium Roof Only
if (isset($_POST['Submit']) && isset($_POST['Medium Roof'])) {
// add comma if necessary to separate
if (!empty($RoofHeight))
{
$RoofHeight = $RoofHeight."', '";
}
$RoofHeight = $RoofHeight."Medium Roof";
}


//High Roof ONLY
if (isset($_POST['Submit']) && isset($_POST['HighRoof'])) {
// add comma if necessary to separate

if (!empty($RoofHeight))
{
$RoofHeight = $RoofHeight."', '";
}
$RoofHeight = $RoofHeight."HighRoof";
}



Can anyone see whats wrong with it?

Thanks in advance

Your Answer:

Login to answer

Other forums

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

How to create a static html menu from a database
Hi,

I have built a small cms which allows me to create simple html pages and then upload them

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

browse folder only
hi,
is there a way i can browse or get the directory or folder only and not the file?
i just w

if else problem, help please
i have this script that i made only i try to also put in a if else for for some reason the script is

Converting from one format to another
"I have got a date in DD/MM/YYYY but I need it in MM-DD-YYYY. Help!"

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

Form errors in an array
I'm processing a form and putting the errors in an array. empty($errors) doesn't seem to do the tric