submitting checkbox data to database

[Methonis]

Alright, here's all I need to do. I have an options page, and I've created some code to pull member groups out of my database, and display them. Each member group has a checkbox which will set the column called 'cantitle'. I'm not sure what query I would need to do to submit the data. Here's the code:

$request = mysql_query("SELECT * FROM `{$db_prefix}membergroups` WHERE ID_GROUP=1 OR ID_GROUP=8;") or database_error(__FILE__, __LINE__);
	while ($row = mysql_fetch_array($request))

{
	echo '
						<tr>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><font size="2">' . $row['membergroup'] . '</font></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><input type="checkbox" name="' . $row['ID_GROUP'] . '" value="' . $row['cantitle'] . '" /></td>
						</tr>';
}

$request = mysql_query("SELECT * FROM `{$db_prefix}membergroups` WHERE `grouptype`=0 AND ID_GROUP>2 AND ID_GROUP!=8;") or database_error(__FILE__, __LINE__);
while ($row = mysql_fetch_array($request))
{
	echo '
						<tr>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><font size="2">' . $row['membergroup'] . '</font></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><input type="checkbox" name="' . $row['ID_GROUP'] . '" value="' . $row['cantitle'] . '" /></td>
						</tr>';
}

echo '
						<tr>
							<td class="titlebg" bgcolor="' . $color['titlebg'] . '" colspan="3">
								<a href="javascript:reqWin(\'' . $scripturl . '?action=helpadmin;help=addctitle\')" class="help"><img src="' . $imagesdir . '/helptopics.gif" border="0" alt="' . $txt[119] . '" /></a>
								<font size="2" class="text1" color="' . $color['titletext'] . '"><b>' . $txt['memtitle2'] . '</b></font>
							</td>
						</tr>';

$request = mysql_query("SELECT * FROM `{$db_prefix}membergroups` WHERE `grouptype`=1;") or database_error(__FILE__, __LINE__);
while ($row = mysql_fetch_array($request))
{
	echo '
						<tr>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><font size="2">' . $row['membergroup'] . '</font></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"><input type="checkbox" name="' . $row['ID_GROUP'] . '" value="' . $row['cantitle'] . '" /></td>
						</tr>';
}
if (mysql_num_rows($request) < 1)
{
	echo '
						<tr>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '"></td>
							<td class="windowbg2" bgcolor="' . $color['windowbg2'] . '" colspan="2">' . $txt['memtitle3'] . '</td>
						</tr>';
}

I thought it might be something like this, but I'm not too sure:

$request = mysql_query("SELECT ID_GROUP FROM `{$db_prefix}membergroups`;") or database_error(__FILE__, __LINE__);
	while ($row = mysql_fetch_array($request))
	{
		$id_group = $row['ID_GROUP'];
		$can_title = $row['cantitle'];
                                $request2 = mysql_query("UPDATE {$db_prefix}membergroups SET cantitle='$can_title' WHERE ID_GROUP='$id_group';") or database_error(__FILE__, __LINE__);
	}

That doesn't work as is...do I need to a foreach command or something? Kinda still learning all of this stuff.

Any help is appreciated,

Methonis

[valshooter]

I think when you are doing smth like this:

$request = mysql_query("SELECT ID_GROUP FROM `{$db_prefix}membergroups`;") or database_error(__FILE__, __LINE__); 
    while ($row = mysql_fetch_array($request)) 
    { 
        $id_group = $row['ID_GROUP']; 
        $can_title = $row['cantitle']; 
                                $request2 = mysql_query("UPDATE {$db_prefix}membergroups SET cantitle='$can_title' WHERE ID_GROUP='$id_group';") or database_error(__FILE__, __LINE__); 
    }

You get the problem because you HAVE ONLY ONE MYSQL CONNECTION OPEN

IMHO try this:

$ar = array();
$request = mysql_query("SELECT ID_GROUP FROM `{$db_prefix}membergroups`;") or database_error(__FILE__, __LINE__); 
    while ($row = mysql_fetch_array($request)) 
    { 
        $id_group = $row['ID_GROUP']; 
        $can_title = $row['cantitle']; 
        $ar[] = array($id_group, $can_title);
    }

foreach ($ar as $couple)
        {
        $id_group = $couple[0];
        $can_title = $couple[1];
        $request2 = mysql_query("UPDATE {$db_prefix}membergroups SET cantitle='$can_title' WHERE ID_GROUP='$id_group';") or database_error(__FILE__, __LINE__); 
    }        

In other words:
0. Query database
1. save all data that needs to be updated
2. Update data

Hope this helps