$flagi = 0;
$flage = 0;
$flagv = 0;
$flagf = 0;
$flagw = 0;
$flago = 0;
$flagh = 0;
$flagm = 0;
$flagn = 0;
$flagx = 0;
$flagss = 0;
$flagr = 0;
$flaga = 0;
if(in_array('i', $_POST['liquorreporttype'])) { $flagi = 1; }
if(in_array('e', $_POST['liquorreporttype'])) { $flage = 1; }
if(in_array('v', $_POST['liquorreporttype'])) { $flagv = 1; }
if(in_array('f', $_POST['liquorreporttype'])) { $flagf = 1; }
if(in_array('w', $_POST['liquorreporttype'])) { $flagw = 1; }
if(in_array('o', $_POST['liquorreporttype'])) { $flago = 1; }
if(in_array('h', $_POST['liquorreporttype'])) { $flagh = 1; }
if(in_array('m', $_POST['liquorreporttype'])) { $flagm = 1; }
if(in_array('n', $_POST['liquorreporttype'])) { $flagn = 1; }
if(in_array('x', $_POST['liquorreporttype'])) { $flagx = 1; }
if(in_array('s', $_POST['liquorreporttype'])) { $flagss = 1; }
if(in_array('r', $_POST['liquorreporttype'])) { $flagr = 1; }
if(in_array('a', $_POST['liquorreporttype'])) { $flaga = 1; }

require_once('config.php');
      $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Failed to connect to server');
    $db = mysql_select_db(DB_DATABASE) or die("Unable to select database")
$qry = sprintf("INSERT INTO masterliquorincident (declarename, usercreating, useroccupation, venueid, flagi, flage, flagv, flagf, flagw, flago, flagh, flagm, flagn, flagx, flagss, flagr, flaga) VALUES ('%s', '%s', '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d,)", mysql_real_escape_string($_POST['declarename']), mysql_real_escape_string($_SESSION['SESS_FIRST_NAME']) mysql_real_escape_string($_SESSION['SESS_LAST_NAME']) mysql_real_escape_string($_SESSION['SESS_MEMBER_ID']),mysql_real_escape_string($_POST['declareocc']), mysql_real_escape_string($flagi),mysql_real_escape_string($flage),mysql_real_escape_string($flagi),mysql_real_escape_string($flagf),mysql_real_escape_string($flagw),mysql_real_escape_string($flago),mysql_real_escape_string($flagh),mysql_real_escape_string($flagm),mysql_real_escape_string($flagn),mysql_real_escape_string($flagx),mysql_real_escape_string($flagss),mysql_real_escape_string($flagr),mysql_real_escape_string($flaga) ;
$result = mysql_query($qry);