Inserting into the database using dynamically created checkboxes

[funty2]

Hi,
Please i need help with the code for inserting into my database. I created some checkboxes dynamically (i mean not form check boxes), the value check by the user is to be inserted into the database.

Here is a portion of my code.

<?php
mysql_select_db($database_sims, $sims);
function display_db_query($query_string, $connection,$header_bool, $table_params)
{
$query_creg100 = "SELECT Course_code as 'Course Code', Course_status as 'CourseStatus' , Course_desc as 'Course Description', Course_unit as 'Course Unit' FROM courses where course_level ='100'";
// perform the database query
$creg100 = mysql_query($query_creg100) or die(mysql_error());
//$query_string = mysql_query($query_string, $connection) or die(mysql_error());
// find out the number of columns in result
$column_count = mysql_num_fields($creg100)or die(mysql_error());
// TABLE form includes optional HTML arguments passed into function
print("<TABLE $table_params >\n");
// optionally print a bold header at top of table
if ($header_bool){
print("<TR>");
for ($column_num = 0;$column_num < $column_count;$column_num++){
$field_name =mysql_field_name($creg100, $column_num);
print("<TH>$field_name</TH>\t");
}
print("<TH>CHECK</TH>");
print("</TR>\n");
}
// print the body of the table
while ($row = mysql_fetch_row($creg100)){
print("<TR ALIGN=LEFT VALIGN=TOP>");
for ($column_num = 0;$column_num < $column_count;$column_num++){
print("<TD>$row[$column_num]</TD>");
}
print("<TD><input type =\"checkbox\" name =". $row[course_code]. "value = $row[course_code] ></TD>\n");
print("</TR>\n");

			}
			print("</TABLE>\n"); 
		}
		function display_db_table($connection,$header_bool, $table_params){
		//$query_string = "SELECT * FROM $tablename";
		$query_string = "SELECT Course_code, Course_status, Course_desc, Course_unit FROM courses where course_level ='100'";
		display_db_query($query_string, $sims,$header_bool, $table_params);
	}

	mysql_select_db($database_sims,$sims);
	if (isset($_REQUEST['Submit']))
	{		
	$query_creg100 = "SELECT Course_code, Course_status, Course_desc, Course_unit FROM courses where course_level ='100'";
	$register = mysql_query($query_creg100) or die (mysql_error());
	while ($row = mysql_fetch_array($register))
		{
			if (($_POST[$row[course_code]] != ""))
			$query_insert = "INSERT INTO register (matricno,'c_code','score','session') values ('$_POST[textfield]', '$creg[course_code]','','$_POST[session]')";
			$sumunit = 0;
			$sumunit += $row[course_unit];
			$result = mysql_query($query_insert,$sims);
		}
}		


?>

Please go through it, I can't figure out what's wrong.
I will appreciate if i can get a fast response
Thanks in advance

[Piranha]

Please use the [ php] [ /php] tags when posting code (without the spaces).

[dmacman1962]

Yes, the

 tags help with us viewing your code.

I just did the same thing and heres what I used. (change the names for your checkboxes).

[code=php]
$xx=0;
foreach($_POST['arrayname'] as $xx => $field) {
  $sql ="insert into table";
  $sql .="(field) ";
  $sql .="values ('$field')";
  	if(!mysql_query($sql)){
			echo mysql_errno().'<br>'.mysql_error().'<br><br>';
	}

} 

I did not test this, but it should help guide you.

Good luck,
Don