 |
|
|
$sql_l="select * from content_roiweb where type='banner_l' order by rand() limit 0,1";
$query_l=mysql_query($sql_l);
$rec_l=mysql_fetch_array($query_l);
$banner_l=$rec_l[image];
$link_l=$rec_l[link]
?>
 |
include('help_support.php');?> |
|
New Product |
//query product update
$sql_p="select ifnull(spd_title_th , spd_title_en) ,spp.spp_picture_small, spf.spf_id_pk, spf.spf_shop_url, spd.spd_id_pk from shop_product spd , shop_profile spf , shop_product_picture spp , member_roiweb mr where (mr.spf_id_pk=spf.spf_id_pk) and (spf.spf_id_pk = spd.spf_id_pk) and (spd.spd_id_pk= spp.spd_id_pk) and spf.gencode_type_id='NA' and (mr.spf_id_pk!=0 or spf.spf_id_pk!='') order by spd.spd_update_date_time desc limit 0,5";
$query_p=mysql_query($sql_p);
while($rec_p=mysql_fetch_array($query_p)){
// get path image
$vStrSessionShopDir=$rec_p[3];
$_vStrPathShopImgLib = _vStrRootPath . "../" . $vStrSessionShopDir . "/" . _vStrDirImgLib;
//
?>
|
}?>
|
|
|