7) error("Invalid status"); $select = $db->prepare("SELECT timeStatus, status FROM sent WHERE id=:id AND gate=(SELECT id FROM gates WHERE address=:address)"); if(!$select->execute(array(":address" => $_SERVER['REMOTE_ADDR'], ":id" => $id))) error("Unable to retrieve gate details"); if($g = $select->fetch()) { if($g['timeStatus'] || $g['status'] != 0) error("This status has already been set: ".$g['status']); $update = $db->prepare("UPDATE sent SET `status`=:status, `timeStatus`=NOW() WHERE `id`=:id"); if(!$update->execute(array(":id" => $id, ":status" => $status))) error("Failed to update database"); else echo json_encode(array("id" => $id, "status" => $status)); } else error("You're not allowed to do this"); ?>