Input Checkbox and PHP $_POST

I've got an

<input type="checkbox" name="Display" value="Yes" />

Code (markup):

The print_r of $_POST

Array ( [Display] => Yes ) 

Code (markup):

and obviously, if the checkbox is not checked, then [Display] doesn't feature.

But later I have

if (isset($_POST['Display'])) {
  $display = 1;
} else {
  $display = 0;
}

Code (markup):

I get:

MySQL Error: Unknown column 'Display' in 'field list'

Code (markup):

What is going on?

I thought I was doing the right thing with isset!

 

The error you are getting is from MySQL query, and doesn't have "anything" to do with these _POST variables.

Without seeing more of the script it's hard to help more.

Do you have Display column in your database table?

 

It's clearly said that there's no column called 'Display' - add it and it'll disappear !

 

Ah, yes...

I was so fixated on the Display bit from the form, that I totally missed the fact that the error was a MySQL error and not a form thing...

Thanks everyone for pointing that out!