prepare("SELECT field1,field2,field3,field4,field5,field6 FROM form_fields WHERE field4 = :field4"); $data = array( ':field4' => $var4 ); $query->execute($data); $row = $query -> fetch(); // set the field name variables $field1 = $row['field1']; $field2 = $row['field2']; $field3 = $row['field3']; $field4 = $row['field4']; $field5 = $row['field5']; $field6 = $row['field6']; //separate the checkbox array Check 1, Check 2, Check 3 $checked = explode(', ',$field5); // set a variable for each of the 3 possible checkbox options $fielda = $checked[0]; $fieldb = $checked[1]; $fieldc = $checked[2]; } ?>