Updating via a form [checkboxes]

[josephman1988]

So I have various checkbox fields in my form that inputs data into my db.

These boxes are 'subseries' to the 'game' being edited, so say if i tick 5 boxes, them 5 box values are associated to this game via a 3rd table.

 

I have done this so when updating, the already ticked boxes before the update are ticked.:

$result = mysql_query( "SELECT * FROM subseries LEFT JOIN subseriesgamesconnect ON (sId=subseriessId AND gamesgId=$gId)" );
while ( $row = mysql_fetch_assoc( $result ) ) {
     if ( !empty( $row["gamesgId"] ) ) { $checked = " checked=\"checked\""; } else { $checked = ""; }
     print "<input type=\"checkbox\" name=\"subseries[".$row["sId"]."]\" ".$checked." /> ".$row["sName"]."<br />";
}

 

The way I want to do it, is instead of using UPDATE, im wanting to DELETE the data that is null, or 'not ticked' and INSERT if the box is ticked, however, the INSERT part doesnt seem to be working .. the DELETE part is working fine though.:

mysql_query( "DELETE FROM subseriesgamesconnect WHERE gamesgId=$gId" );
foreach( $_POST['subseries'] as $subseries => $checked ) {
    if ( $checked == 1 )
        mysql_query("INSERT INTO subseriesgamesconnect VALUES ( $subseries, $gId )");
	}

What am I overlooking?

Thanks.

[BlueSkyIS]

need to see more code.

 

[D3v 7oW]

By ticked, do you mean checked?

[josephman1988]

By ticked, do you mean checked?

 

Yep.

 

Blue, what more code do you want? Thats basically it, other then that there is the actual form itself .. I haven't added the INSERT querys for other fields as of yet but I don't think that's the problem.

[D3v 7oW]

If those two codes are on the same page or in the same statement, that is also incorrect.

[josephman1988]

If those two codes are on the same page or in the same statement, that is also incorrect.

 

It is on the same page ... I wanted, upon submission for it to update .. how would I do it otherwise then?

[D3v 7oW]

if(empty($_POST['subseries']))
{
   $result = mysql_query( "SELECT * FROM subseries LEFT JOIN subseriesgamesconnect ON (sId=subseriessId AND gamesgId=$gId)" );
   while ( $row = mysql_fetch_assoc( $result ) ) {
        if ( !empty( $row["gamesgId"] ) ) { $checked = " checked=\"checked\""; } else { $checked = ""; }
        print "<input type=\"checkbox\" name=\"subseries[".$row["sId"]."]\" ".$checked." /> ".$row["sName"]."<br />";
   }
}
else
{
   foreach( $_POST['subseries'] as $subseries => $checked ) {
       if ( $checked == 1 )
           mysql_query("DELETE FROM subseriesgamesconnect WHERE gamesgId=$gId" );
           mysql_query("INSERT INTO subseriesgamesconnect VALUES ( $subseries, $gId )");
   }
}

 

inside of the statement for if the $_POST['subseries'] is empty you would also need to be the beginning to the form and the end of it

[D3v 7oW]

if(empty($_POST['subseries']))
{
   $result = mysql_query( "SELECT * FROM subseries LEFT JOIN subseriesgamesconnect ON (sId=subseriessId AND gamesgId=$gId)" );
   while ( $row = mysql_fetch_assoc( $result ) ) {
        if ( !empty( $row["gamesgId"] ) ) { $checked = " checked=\"checked\""; } else { $checked = ""; }
        print "<input type=\"checkbox\" name=\"subseries[".$row["sId"]."]\" ".$checked." /> ".$row["sName"]."<br />";
   }
}
else
{
   foreach( $_POST['subseries'] as $subseries => $checked ) {
       if ( $checked == 1 )
           mysql_query("DELETE FROM subseriesgamesconnect WHERE gamesgId=$gId" );
           mysql_query("INSERT INTO subseriesgamesconnect VALUES ( $subseries, $gId )");
   }
}

 

inside of the statement for if the $_POST['subseries'] is empty you would also need to put the beginning to the form and the end of it