include_once 'events_city_list.php'; ?>
$countryid=0;
$pastonid=0;
include 'activity_list.php';
?>
|
 |
 |
$pagesize = 5;
$page = empty($_GET['pg']) ? 1 : $_GET['pg'];
$offset = $pagesize * ($page - 1) ;
$sqltotal = "select count(*) from qEvents WHERE qEn=0 and qOn=1 and qMember=0 and qPaston=1 and a.qCountry=$countryid ;";
$totalrows = TotalRows($sqltotal);
$totalpages = intval($totalrows/$pagesize);
if ($totalrows % $pagesize) $totalpages++;
$oplimit = "LIMIT $offset,$pagesize";
$sql = "SELECT a.*,b.qPath,b.qFilename,b.qTitle as phototitle FROM qEvents a ".
"LEFT JOIN qEventsphoto b on a.qID = b.qEventid and b.qMain=1 ".
"WHERE a.qEn=0 and a.qOn=1 and a.qMember=0 and a.qPaston=1 and a.qCountry=$countryid ORDER BY a.qDate DESC, a.qID desc $oplimit";
$conn = qingtian_connect_database("qingtian_main");
$result = mysqli_query($conn,$sql) or die("Error in query $sql " . mysqli_error($conn));
while ($row = mysqli_fetch_array($result)) {
//if (date('Y-m-d',strtotime($row['qDate'])):: '.$row['qTitle'].' :: | ';
//echo ' | ';
echo '';
if(!empty($row['qFilename'])){
echo ' ';
}
else
echo ' ';
//echo ' | | ';
echo '';
echo ''.
// date('Y-m-d',strtotime($row['qDate'])).BR.
// $row['qLocation'].BR.
//vertext($version,'日期:','Date: ').date('Y-m-d',strtotime($row['qDate'])).BR.
// '地点:'.$row['qLocation'].BR.
/*
vertext($version,'时间:','Time: ').$row['qTime'].BR.
vertext($version,'地点:','Location: ').$row['qLocation'].BR.
vertext($version,'邀请人数:','Invitatory persons: ').$row['qNumber'].BR.
vertext($version,'联 系 人:','Contact: ').$row['qContact'].BR.
vertext($version,'联系电话:','Phone: ').$row['qPhone']. */
''.
cn_left(clear(($row['qContent'])),50).
' | '.
' '.
((!empty($phototitle)) ? $phototitle: ' ').' | '.
''.
''.'活动报道'.' » | ';
// ' | ';
// } // end of if
} // end of while
mysqli_free_result($result);
if ($totalrows>0){
echo '更多以往活动 » | ';
// echo ''.paging($totalrows,$totalpages,$page,$pagesize,"gp=$groupname&gpid=$gpid",$version).' | '.CR;
}
// else
// echo 'No record is found. | '.CR;
?>
|