include("db_conn.php");
$sql = "SELECT cmpny_list.hal_int, cmpny_list.hl_id, cmpny_list.hal_type, cmpny_list.cmpny_name_th, hl_list.hl_code, tb_province.p_id FROM cmpny_list";
$sql = $sql." LEFT JOIN hl_list ON hl_list.hl_id=cmpny_list.hl_id";
$sql = $sql." LEFT JOIN tb_province ON tb_province.p_id=cmpny_list.addr_province1";
$sql = $sql." WHERE cmpny_list.hal_int='$_GET[id]'";
$sql = $sql." GROUP BY cmpny_list.hl_id";
$result = mysql_db_query( $dbname, $sql);
$row = mysql_fetch_array($result);
if ( $_GET["tag"]==1 ) {
mysql_db_query($dbname, "UPDATE support_company SET click_view=click_view+1, last_view=now() WHERE hl_id='$row[hl_id]'");
} else if ( $_GET["tag"]==2 ) {
mysql_db_query($dbname, "UPDATE support_restaurant SET click_view=click_view+1, last_view=now() WHERE hl_code='$row[hl_code]'");
} else if ( $_GET["tag"]==3 ) {
mysql_db_query($dbname, "UPDATE support_product SET click_view=click_view+1, last_view=now() WHERE hl_code='$row[hl_code]'");
}
if ( $row["hal_type"]==4 ) {
/*echo $row["hal_type"];*/
echo "
";
} else if ( $row["hal_type"]==1 OR $row["hal_type"]==2 OR $row["hal_type"]==5 ) {
/*echo $row["hal_type"];*/
echo "
";
}
?>