checkboxes and radio buttons into a database

irishmaggie

Hi again!
I was wondering is there any way that you can put the value that a checkbox/radio button holds into a table in a database?

I have a form which lets the user click a checkbox as to the number of people travelling on a journey and a list of radio buttons which asks the user the duration of their trip.

Can I place values into a table when these options are clicked and the form is submitted?

Is there any good places that I can get info on this?

Regards,
irishmaggie!*

laserlight

Just name them.

If they have been checked/selected, then you can treat them like the way you would, say a textfield.

MikeA

What I do is set the field as INT with a length of 1. Then store them as follows:

Checkbox - checked = value 1
Checkbox - unchecked = value 0

Same with radio buttons

Then you can do something like:

if ($request_email == 1) {$request_email = "YES";}

inside your script.

irishmaggie

I have a list of checkboxes on the 1st half of the form and a list of radio buttons on the second half and when I say:

   "insert into prices(price_amount, no_pass, duration) values('$HTTP_POST_VARS[total]', '$HTTP_POST_VARS[nopass]', '$HTTP_POST_VARS[duration]')";

(nopass being the name of the checkboxes
&
duration being the radio buttons)

...this will not enter anything into the database, but when I take one of these out, (say $HTTP_POST_VARS[nopass]), it enters the value that was checked in the check box when it should be entering the value that was clicked in the duration radio button???

Very confusing?

Oh and MIKEA....do I insert that if statement into my javascript or into a seperate php linked file?

Cheers guys, your help is really appriciated!

irishmaggie!*