checkboxes in repeat record?

siwy

i have an update form with 2 checkboxes, the table is a repeat region. when you submit the form only the last record gets a value, why? anybody
here is my code

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE games SET accept=%s, decline=%s WHERE c_ID=%s",
                       GetSQLValueString(isset($HTTP_POST_VARS['accept']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($HTTP_POST_VARS['decline']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($HTTP_POST_VARS['c_ID'], "int"));

  mysql_select_db($database_rscontacts, $rscontacts);
  $Result1 = mysql_query($updateSQL, $rscontacts) or die(mysql_error());
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE games SET accept=%s, decline=%s WHERE c_ID=%s",
                       GetSQLValueString(isset($HTTP_POST_VARS['accept']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($HTTP_POST_VARS['decline']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($HTTP_POST_VARS['c_ID'], "int"));

  mysql_select_db($database_rscontacts, $rscontacts);
  $Result1 = mysql_query($updateSQL, $rscontacts) or die(mysql_error());
$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_update"])) && ($HTTP_POST_VARS["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE games SET accept=%s, decline=%s WHERE c_ID=%s",
                       GetSQLValueString(isset($HTTP_POST_VARS['accept']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($HTTP_POST_VARS['decline']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($HTTP_POST_VARS['c_ID'], "int"));

  mysql_select_db($database_rscontacts, $rscontacts);
  $Result1 = mysql_query($updateSQL, $rscontacts) or die(mysql_error());

csn

2c (of many that could be given) - you don't need to keep calling select_db.

siwy

yeah, i know it's my fault i pasted my code to many times into the message.