my db has members, and statuses. each member can have 1 current status.
I have a code that decides what status to give what member. thing is, it can give 2 possible statuses, and then the site admin should approve one of them(if at all)
I made a report page with a table, each row has a member-status that is waiting approval/decline.
I added a check box near each row so that the admin can check multiple statuses and approve/deny them at one click (added a add/deny all checked button)
but now I have a problem, what if the admin checks 2 boxes for the same member (when there are more than 1 possible status).. this shouldn't be possible, so then I thought, make a radio button instead, but if I group all radio buttons (as I did with the checkboxes, I pass them as an array when the approve all button is clicked) then I can chose only 1 status no matter how many members are in the table..if I group the radio buttons for each member, how do I pass all the radio buttons that were checked using POST?
I can't think on any other solution..
there's also the problem that I don't really know how many statuses each member has, so I can't group them as I print them. I just use the select *from tbl query and it prints the someone's status 1 by 1 so how can I know who's will be the next status printed? I can only check after it's printed if it's the same as the one before..
hmm...need help ASAP please! sort of last minute mistake I found, too stressed to even think straight!