";
echo "
| RECORD ID |
BRAND NAME |
ACTION |
";
while($row=mysql_fetch_array($result)){
?>".$row['id']."";
echo "| ".$row['brand_name']." | ";
echo"";
?> | ";
}
echo "";
exit();
}
if(isset($_POST['AddNew'])){
$selUserID = mysql_escape_string($_POST['selUserID']);
$brandID = mysql_escape_string($_POST['brandID']);
$brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='$brandID'"),0);
$getIFexist = mysql_result(mysql_query("SELECT COUNT(brand_id) FROM `brand_access` WHERE `user_id`='$selUserID' AND `brand_id`='$brandID'"),0);
if($getIFexist==0){
mysql_query("INSERT INTO brand_access (id, user_id, brand_name, brand_id)
VALUES('','{$selUserID}','{$brandName}','{$brandID}')");
}
$result = mysql_query("SELECT * FROM brand_access WHERE `user_id` = '$selUserID' ORDER BY `brand_name` ASC");
echo "";
echo "
| RECORD ID |
BRAND NAME |
ACTION |
";
while($row=mysql_fetch_array($result)){
?>".$row['id']."";
echo "| ".$row['brand_name']." | ";
echo"";
?> | ";
}
echo "
";
exit();
}
if(isset($_POST['deleteNow'])){
$deleteAccessID = mysql_escape_string($_POST['deleteAccessID']);
mysql_query("DELETE FROM `brand_access` WHERE `id` = '$deleteAccessID'");
echo "Recordd has been deleted.
";
exit();
}
?>