Inserting/updating radio buttons

keiichi

Hi, I din'd know if this one goes in php or mysql thread... so if I'm wrong ..I'm sorry.

I'm trying to write a script that can handle multiple updates of radio buttons.
I need to grab the selections from a query, display it, edited and the update the changes.

I have done this multiple times, but only with one set of radio.
Those radio buttons are for activate or deactivate options.

This is an example:

Option              A | D
--------             -------

Option 1             X
Option 2                 X
Option 3             X
Option 4             X

And so on...

I havent write any code yet because I dont know how to start... 🙁

Hope somebody can helpeme here.

maxpup979

create a table with a structure that has the option, and the status. I would recommend using bool for the datatype of your status field. If your DB doesnt have bool, most support something similar like tinyint.
Once you have the table, and data added to the table, all you have to do is look up the records, and then loop through them. when you get to the radio buttons, check to see what the status is, and then set the appropriate button as relates to the status.

keiichi

maxpup979 wrote:
create a table with a structure that has the option, and the status. I would recommend using bool for the datatype of your status field. If your DB doesnt have bool, most support something similar like tinyint.
Once you have the table, and data added to the table, all you have to do is look up the records, and then loop through them. when you get to the radio buttons, check to see what the status is, and then set the appropriate button as relates to the status.

Yup I already have a table, but I used the enum type to set the status.


ENUM ('yes','no') DEFAULT 'no'

I now how to handle the radio buttos. What I don't know is whot to update, let's say 20 options with its corresponding 'yes'/'no'.

Basically I need to query the db, load the values to the apropiate state (enable or disable). Here the user makes his changes. Then grab those changes and compare them with those stored in the DB and update those that have changed. For that I need a way to update multiple rows in the database.. and there is my problem, how to identify those rows that have changed.

TIA

maxpup979

or dont bother with updating only rows that have changed. update all of them. the ones that have changed will be different, but the ones that haven't you will be updating to their previous state. Going to be more efficient this way.

keiichi

maxpup979 wrote:
or dont bother with updating only rows that have changed. update all of them. the ones that have changed will be different, but the ones that haven't you will be updating to their previous state. Going to be more efficient this way.

You are right.. 😃

I haven't saw that way....

But if you can helpme with the code that I may use.. would be really nice.

TIA

keiichi

anyone?

please?