-
'$todate' and ads_use='Y' and ads_role='b2b' order by ads_order";
$result=mysql_query($query,$dbconn);
$no=0;
while($row=mysql_fetch_assoc($result)){
$ad_uid =$row["ads_uid"]; //int(11) PRI NULL auto_increment
$ad_imgfn =$row["ads_imgfn"]; //text
$ad_size_w =$row["ads_size_w"]; //int(4) 0
$ad_size_h =$row["ads_size_h"]; //int(4) 0
$ad_link =$row["ads_link"]; //text
$ad_use =$row["ads_use"]; //enum('Y','N') Y
$ad_role =$row["ads_role"]; //varchar(15) Y
$ad_comment =$row["ads_comment"]; //text YES NULL
$ad_for =$row["ads_for"]; //enum('PC','MOBILE') PC
$ad_sdate =$row["ads_sdate"]; //varchar(8)
$ad_edate =$row["ads_edate"]; //varchar(8)
$ad_user =$row["ads_user"]; //varchar(20)
$ad_signdate=$row["ads_signdate"]; //varchar(12)
$ad_open_type=$row["ads_open_type"]; //varchar(12)
$ad_product_id=$row["ads_product_id"]; //varchar(12)
if($no==0) $active='active';
else $active='';
if(!strpos($ad_link,"http")) $ad_link="http://".$ad_link;
$ad_link_print='';
echo $ads_product_id;
$slide_li.='';
$slide_html='
- '.$ad_link_print.'
