checkboxes and PHP and MYSQL

[Gladiator2043]

I want to know how this si to be done in the best way:

I have a MYSQL database with vehicle options as check boxes e.g
leather, sunroof etc.

I have a form in which I have all the check boxes....what should I set the checked value to? should I leave it the same as "leather" , "sunroof" etc or should I leave it as 1.

also when I am inserting the form into my mysql database......what kind of code can i use ? i mean do I hav to check for each check box if its been checked or what?

please help

[Mordecai]

It doesn't matter what the value is: if it's set, it's checked, if it's not set, it's not checked.

When inserting, I would go through each (a simple foreach, perhaps even a for) and assign it a value, TRUE or FALSE (1 or 0), depending on whether or not it is set ([man]isset/man). Then, just [man]mysql_query/man away.

[Gladiator2043]

should i name my check boxes ina special way for the for each loop...i mean should i make it an array.......i feel arrays are confusing. could you give me a little code sample.

e.g.
my mysql table has the following columns

(text) make, (text) model, (text) year, bool (front ac), bool (side airbags) etc etc

and my check box is called side_airbags. could you give me a sample of how I coud get it done.