checkbox array thingy

[menelaus8888]

well, i have this page that displays all unverified users. i have a fieldname named "verified" which has a default value of "no" when a new user registers.

 

this is how it looks like

 

verififyusername

 

checkboxhereusername1

checkboxhereusername2

 

 

submit button

 

 

as you can see there are checkboxes on the left which indicates if the user should be verified( change the default value of fieldsname "verified"  "no" to "yes"

 

my code for the checkbox is :

counter - starts from 1 and it increments as to how many unverified users

 

 

<input type=checkbox name=checkbox[counter] value=yes>

 

i can easily display the the name and the value of array checkbox[] using print_r upon the next page but im having trouble in updating it on my database table.

 

i need simple code to update verified "no" to "yes"

 

thanks in advance

 

 

 

[sKunKbad]

if your using mysql, then just do a simple update to each row that needs to have the verified field set to no.