I am attempting to develop a PHP script to record presence at an event for those persons in a mysql table Persons. I am attempting to use checkboxes to indicate who was present. Here is the script as currently written:
<?php # Script
require ('includes/mysqli_connect.php');
if(isset($_POST['checkbox'])) {$checkbox = $_POST['checkbox'];
if(isset($_POST['activate'])?$activate = $_POST["activate"]:$deactivate = $_POST["deactivate"]);
$id = "('" . implode( "','", $checkbox ) . "');" ;
echo $id;
$q="UPDATE Persons SET present = '".(isset($activate)?'Y':'N')."' WHERE id IN $id" ;
$r = mys