$q_issue = "SELECT * FROM `tbl_issue` WHERE `id` = ".$curIssueID ;
$r_info = mysql_query($q_issue, $link) or die(mysql_error());
$r_issue = mysql_fetch_assoc($r_info);
$browser = $_SERVER['HTTP_USER_AGENT'];
if(preg_match('/iPhone|iPad|iPod|Android|Opera|Blackberry/i', $browser)) {
$r_issuelink = "http://m.igafencu.com/ipad/index.php?iid=".$curIssueCode."&lang=hk" ;
$extraInfo = "iPhone ";
} else {
$r_issuelink = $r_issue['urlE'];
$extraInfo = "";
}
echo "";
echo "ISSUE: ".$curIssueTxt." | ";
echo " | ";
?>
|
|
include('3video_en.php'); ?>
|
|
|
mysql_select_db($dbname1, $link ) or die("Could not select database");
$sqlgp = "SELECT * FROM `tbl_group` ORDER BY `iorder` " ;
$q = mysql_query($sqlgp, $link) or die(mysql_error());
while($rgp = mysql_fetch_assoc($q)) {
if ( $rgp['id'] == 7) {
echo "";
} else {
echo "";
echo " | | ";
echo " | ";
echo "".$rgp['groupName']." | ";
//
if (($rgp['id']==6) || ($rgp['id']==8) || ($rgp['id']==10) ) {
$qC = "SELECT * FROM tbl_post WHERE issue_id = ".$curIssueID." AND active=1 AND etitle<>'' AND col_id = ".$rgp['id']." ORDER BY g_id , iorder" ;
} else {
$qC = "SELECT * FROM tbl_post WHERE issue_id = ".$curIssueID." AND active=1 AND etitle<>'' AND g_id = ".getCatInfo($rgp['id'],"id")." ORDER BY g_id , iorder" ;
}
$sC = mysql_query($qC);
$tcode = " | " ;
while ($rC = mysql_fetch_array($sC)) {
if (($rgp['id']==6) || ($rgp['id']==8) ) {
$extraTitle = str_replace("PEOPLE : ","",getEssCatInfo($rC['g_id'],"catName"))." : ";
} else {
$extraTitle = "";
}
$checkVideo = ($rC['urlE'])?" ":"";
$urlCLink = "content_en.php?pid=".$rC['id']."&is=".$rC['issue_id']."&cat=".$rC['g_id'].$extraQStr2."";
$imgfilePath = (strlen($rC['img']) >2 )?$rC['img']:getIssueInfo($rC['issue_id'],"issue")."/th".getEssCatInfo($rC['g_id'],"imgSuffix").$rC['iorder'].".jpg";
$tcode .= " | \r\n";
$tcode .= "".$extraTitle.$rC['etitle']."".$checkVideo." ";
$tcode .= "".$rC['etitleD']."";
//$tcode .= " ...>>";
$tcode .= " | | \r\n";
}
echo $tcode ;
//
echo " ";
}
}
?>
|
|
|
|
include("rightAdv_en.php"); ?>
|
|