function get_advlist($position, $num=0)
{
$arr=array();
$limit_string = '';
if ($num > 0)
{
$limit_string = 'limit '.$num;
}
$sql = "select ap.ad_width,ap.ad_height,ad.ad_id,ad.ad_name,ad.ad_code,ad.ad_link,ad.ad_id,ad.link_man from ".$GLOBALS['ecs']->table('ad_position')." as ap left join ".$GLOBALS['ecs']->table('ad')." as ad on ad.position_id = ap.position_id where ap.position_name='".$position."' and UNIX_TIMESTAMP()>ad.start_time and UNIX_TIMESTAMP() $res = $GLOBALS['db']->getAll($sql); foreach($res as $idx => $row) { $arr[$row['ad_id']]['name'] = $row['ad_name']; $arr[$row['ad_id']]['title'] = $row['link_man']; $arr[$row['ad_id']]['url'] = "affiche.php?ad_id=".$row['ad_id']."&uri=".$row['ad_link']; $arr[$row['ad_id']]['image'] = 'data/afficheimg/'.$row['ad_code']; $arr[$row['ad_id']]['ad_code'] = $row['ad_code']; $arr[$row['ad_id']]['content'] = ""; } return $arr; }
评论列表()