using checkbox[] array to update a string not working

[jacko_162]

I have a page that allows a user to enable / disable multiple options (14x)

 

for some reason the code is running but the database isn't updating and the data isn't being passed.

 

but i don't get the mysql errors, can someone look over my code please and let me know where / what is wrong?

 

code:

<?php
	session_start();
include('Includes/auth.php');
require_once('header.php');
?>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="2">
      <tr>
        <td width="40%" valign="top">
        <div align="right"><a href="settings.php"><img src="img/buttons/main_settings.png" alt="" border="0" /></a><img src="img/spacer.png" alt="" width="10" height="1" /></div>
          <div class="content-box">
<div class="content-box-header">
					<h3>My Test Settings</h3>
		</div>
				<div class="content-box-content">
				  <div>
					  <table width="100%" border="0" cellspacing="0" cellpadding="4">
                            <tr>
                              <td colspan="7" valign="top">
                              <form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<?php
if (isset($submit)) {
  // UPDATE QUERY CODE WHEN SUBMIT IS ENTERED
$str = implode(';',$_POST['checks']);
$insert = "UPDATE 'members' SET
settings='$str'
WHERE member_id='$_SESSION[SESS_MEMBER_ID]'";

if (@mysql_query($insert))
{
?>
                          <script type="text/javascript">
document.location.replace('settings-tests.php');
                          </script>
                          <?php
}
else {
echo('Error in you submission:' . mysql_error() . "<br /><br />" . $sql);}
}

{
    $result=mysql_query("SELECT * FROM members WHERE member_id=$_SESSION[SESS_MEMBER_ID]");
    $row = mysql_fetch_array($result);
    $arr = array();
    $arr = explode(';',$row['settings']);
    $member_id = $row['member_id'];
    $firstname = $row['firstname'];
    $lastname = $row['lastname'];
    $email = $row['email'];
    $membership = $row['membership'];
    $roles = $row['roles'];
    $login = $row['login'];
    ?>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
  <tr>
    <td colspan="2"><h3>Test Results Settings</h3></td>
    <td width="25%"> </td>
    <td width="25%"> </td>
  </tr>
  <tr>
    <td colspan="4"><em>To turn off individual results gloablly across the site please use the following sliders (all results already added will also be made invisable)<br />
      <br />
    </em></td>
    </tr>
  <tr>
    <td width="25%"><div align='right'><strong><em>Salinity:</em></strong></div></td>
    <td width="25%"><input type="checkbox" value="test1" name="checks[]2" <?php echo (in_array("test1",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Phosphate:</em></strong></div></td>
    <td><input type="checkbox" value="test9" name="checks[]10" <?php echo (in_array("test9",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>PH:</em></strong></div></td>
    <td><input type="checkbox" value="test2" name="checks[]3" <?php echo (in_array("test2",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>potassium:</em></strong></div></td>
    <td><input type="checkbox" value="test10" name="checks[]11" <?php echo (in_array("test10",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Ammonia:</em></strong></div></td>
    <td><input type="checkbox" value="test3" name="checks[]4" <?php echo (in_array("test3",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Iodine:</em></strong></div></td>
    <td><input type="checkbox" value="test11" name="checks[]12" <?php echo (in_array("test11",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Nitrite:</em></strong></div></td>
    <td><input type="checkbox" value="test4" name="checks[]5" <?php echo (in_array("test4",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Strontium:</em></strong></div></td>
    <td><input type="checkbox" value="test12" name="checks[]13" <?php echo (in_array("test12",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Nitrate:</em></strong></div></td>
    <td><input type="checkbox" value="test5" name="checks[]6" <?php echo (in_array("test5",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Silica:</em></strong></div></td>
    <td><input type="checkbox" value="test13" name="checks[]14" <?php echo (in_array("test13",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Calcium:</em></strong></div></td>
    <td><input type="checkbox" value="test6" name="checks[]7" <?php echo (in_array("test6",$arr) ? "checked" : ''); ?>/></td>
    <td><div align='right'><strong><em>Temperature:</em></strong></div></td>
    <td><input type="checkbox" value="test14" name="checks[]" <?php echo (in_array("test14",$arr) ? "checked" : ''); ?>/></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Magnesium:</em></strong></div></td>
    <td><input type="checkbox" value="test7" name="checks[]8" <?php echo (in_array("test7",$arr) ? "checked" : ''); ?>/></td>
    <td></td>
    <td></td>
  </tr>
  <tr>
    <td><div align='right'><strong><em>Alkalinity:</em></strong></div></td>
    <td><input type="checkbox" value="test8" name="checks[]9" <?php echo (in_array("test8",$arr) ? "checked" : ''); ?>/></td>
    <td colspan="2" align="right"></td>
    </tr>
  <tr>
    <td colspan="4" align="right"><table border="0" cellspacing="0" cellpadding="8">
      <tr>
        <td><input class="btn btn-success btn-rad" type="submit" name="submit" value="Submit" /></td>
      <td><input class="btn btn-danger btn-rad" type="reset" name="reset" value="Reset" /></td>
    </tr>
    </table></td>
    </tr>
</table>
</form>
                           </td>
                        </tr>
                      </table>
					</p>
				  </div> 
				</div> <!-- End .content-box-content -->
                </div>
        </td>
  </tr>
</table>
<?php
}
require_once('footer.php');
?>
</body>

the array explodes, and it shows me "checked" boxes where the data is in the database, just not updating the database table..

 

thank you.

[Barand]

 

 

if (isset($submit)) {

 

Where is $submit being set?