Check Box, 10 numbers, can only pick 5? How to submit to SQL?

[Stryves]

Hello!

 

I've been using the Option / Select form to do this so far, where I offer 5 forms that count 1 2 3 4 5 6 7 8 9 10.

 

The SQL table is ID, n1, n2, n3, n4, n5

 

I Just take whats been submitted throw the above dropdown select menu, but I've been getting ridiculous amount of requests, to offer a format like the below using check boxes.

 

[] 1 [] 2 [] 3 [] 4 [] 5

[] 6 [] 7 [] 8 [] 9 [] 10

 

My problem is, using a method like this where the above is check boxes, I don't know how to assign the value to the sql n1 field. I'm also at a loss as to what would prevent them from select 6 numbers...

 

I have a feel I better read up more on arrays... Any ideas?

[phpretard]

Post your your form code.