$T1 = 0; $T2 = 0;
$qStatis = "SELECT p.p_id, p.p_name,";
//$qStatis = $qStatis." (SELECT COUNT(hl_id) FROM hl_list h WHERE h.hl_id IN (SELECT hl_id FROM cmpny_list c WHERE c.addr_province1=p.p_id AND c.hal_type=4)) AS T2";
$qStatis = $qStatis." (SELECT SUM(c.list_product) FROM cmpny_list c WHERE c.addr_province1=p.p_id AND c.hal_type=4) AS T2";
$qStatis = $qStatis." FROM tb_province p";
$qStatis = $qStatis." WHERE p.set_conf=1";
$qStatis = $qStatis." GROUP BY p.p_id ORDER BY p.p_name ASC";
$objStatis = mysql_db_query($dbname, $qStatis);
?>
while ( $rstStatis = mysql_fetch_array($objStatis) ) {
$T2 = $T2 + $rstStatis["T2"];
if ( $rstStatis["T2"] != 0 ) {
?>
-
(0)
}
}
?>
ร้านอาหารพื้นที่ใกล้เคียง
while ($rcstRst = mysql_fetch_array($rsltRst)) {
$qP = "SELECT * FROM hl_pict WHERE hl_code='$rcstRst[hl_code]' ORDER BY hal_int ASC LIMIT 0, 1";
$objP = mysql_db_query($dbname, $qP); $nP = mysql_num_rows($objP);
?>
-
if ( $nP == 0 ) {
?>
} else {
?>
}
?>
}
?>