it will not update the data base on click
<?php
include "dbc.php";
if (isset ($_POST['loa'])){
//box was ticked
//do database connect here
$queryABC = "Update user_name set status = 'loa' where id ='$id'";
mysql_query($queryABC);
//close db here
}
else
{
//box was not ticked
//do database connect here
$queryABC = "";
mysql_query($queryABC);
//close db here
}
?>
$_POST[‘Loa’] - Match the name of the checkbox. Case sensitive.
Move away from mysql and use PDO or mysqli
If that is all you have, it still wont work after previous fix. There is no form action or javascript on click function to submit the value.
I’m guessing a lot of code has been removed when he posted the question