December 4, 2008 08:43am pst

1. hielo 1,137,229
2. hernst42 478,346
3. angelIII 396,535
4. Ray_Pas... 306,645
5. logudotcom 215,802
6. routinet 212,638
7. bportlock 156,982
8. glcummins 150,531
9. RQuadling 145,758
10. Roonaan 141,868
11. cxr 130,280
12. yodercm 125,579
13. nplib 116,674
14. fibo 100,735
15. Xyptilon2 96,157
16. rowejd 84,483
17. dr_dedo 84,082
18. gamebits 71,755
19. MMDevelo... 67,444
20. TerryAtO... 62,060
21. jausions 60,640
22. Squinky 59,444
23. jason1178 58,923
24. mankowitz 57,440
25. psimation 56,234

1. hielo 1,154,154
2. hernst42 1,034,219
3. angelIII 981,702
4. ldbkutty 688,003
5. Roonaan 669,808
6. RQuadling 528,371
7. wasifg 507,953
8. glcummins 421,844
9. snoyes_jw 401,445
10. gamebits 327,659
11. yodercm 317,815
12. i_m_aa... 314,147
13. routinet 312,487
14. Ray_Pas... 306,645
15. steelseth12 306,629
16. TeRReF 266,490
17. nizsmo 242,915
18. Diablo84 239,472
19. bportlock 233,812
20. logudotcom 222,770
21. dr_dedo 218,197
22. Raynard7 215,268
23. akshah123 211,024
24. WoodyRo... 207,207
25. nplib 186,898

06.17.2008 at 10:54AM PDT, ID: 23492532

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.7

Insert dynamic checkbox values into multiple mysql fields using php

Asked by oneoakgirl in PHP and Databases, PHP Scripting Language, MySQL Server

I need to insert dynamically populated checkbox values into multiple fields of a mysql database using php. I think I need a "for each" statement, but can't seem to get it right.
Here's the php (while statement) that sets up the checkboxes - this works:

// Show records by while loop.
while($rows=mysql_fetch_array($list)){
?>
<input name="nominee" type="checkbox" id="nominee[]" value="<?php echo $rows['n_uuid']; ?>">  <?php echo $rows['n_first']; ?> <?php echo $rows['n_last']; ?> - <?php echo $rows['n_uuid']; ?><br />
<?php
// End while loop.
}
?>

Now - I'm stuck on my insert...
As I said - I need to insert all checked values into one row, separate fields in the database

This is for an election voting process for the staff senate. There are 8 clusters A,B,C,D, etc. involved with a total of about 300 voters.

The voters login and are authenticated through LDAP - then through a table with all voters names. If they aren't in that table - they can't vote.

Once authenticated, they are presented with this dynamically populated checkbox list with nominees from their cluster. Each cluster has a different amount of seats open for nomination so the checked boxes will be different amounts each time.

If I can just get them into separate fields of the database, I'll be happy.
Thanks for your help.
Debra
Start Free Trial

Keywords: Insert dynamic checkbox values into m…

	Title
1	MYSQL/LDAP Dual Query - PHP Cod…
2	Is mysql cluster aware?
3	PHP VOTING - Time Interval Check
4	PHP MySQL connection error?
5	PHP MySQL query join?
6	PHP MySQL query IF statement?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Insert dynamic checkbox values into multiple mysql fields using php

Asked by oneoakgirl in PHP and Databases, PHP Scripting Language, MySQL Server

About this solution