MySQL and Radio buttons

I am having some trouble getting a set of radio buttons to be linked with a db field.

Does anyone have an example of the code, setting "checked" according to the contents of a db field, and then updating the field according to the user edit?

Cheers

Brian

You may want to take a look at this other class that can be used to integrate the forms class with the database access.

phpclasses.org/databaseaccess

I can't see any code in there relevant to radio buttons and db fields.

My problem is that I have some code to set the "checked" parameter to the input tag, which works fine on the first pass, but once the form has been submitted (and when the radio button position has been changed), the code resets it back to what it was, consequently the original value is written back to the db in the "doit" branch. I am sure there must be a trick to it, but I can't quite see what.

Some code using a db field, radio buttons and your forms class which works, would help me no end.

When you have forms with radio and checkbox fields, you need to pass a flag to the LoadInputValues function to specify whether the form is being presented to the user for the first time or it is being submitted.

I am following your example exactly, so I have this:

$form->LoadInputValues($form->WasSubmitted("doit"));

where "doit" is a hidden field.

B.