h1

reset(); $sql=" select* from table_about where hienthi=1 and noibat=1 and type='tin-tuc' order by stt "; $d->query($sql); $tintuc_nbat=$d->result_array(); $d->reset(); $sql=" select* from table_doitac where hienthi=1 and com='thuonghieu' order by stt "; $d->query($sql); $quangcao_r=$d->result_array(); $d->reset(); $sql=" select* from table_yahoo where hienthi=1 order by stt "; $d->query($sql); $hotrotructuyen=$d->result_array(); $d->reset(); $sql=" select* from table_product_list where hienthi=1 and com=1 and id_parent=0 order by stt "; $d->query($sql); $cat_left=$d->result_array(); $d->reset(); $sql=" select* from table_about where hienthi=1 and noibat<>0 and type='dich-vu' order by stt "; $d->query($sql); $dichvu=$d->result_array(); $d->reset(); $sql=" select* from table_about where hienthi=1 and noibat<>0 and type='tin-tuc' order by stt "; $d->query($sql); $tintuc=$d->result_array(); $d->reset(); $sql_doitac1 = "select ten_vi as ten,tenkhongdau,id, photo,thumb,mota from #_doitac where com='qc' and hienthi =1 order by stt,id desc"; $d->query($sql_doitac1); $qc = $d->result_array(); $d->reset(); $sql=" select* from table_video where hienthi=1 and noibat<>0 order by stt "; $d->query($sql); $video=$d->fetch_array(); $d->reset(); $sql="select * from #_province order by provinceid"; $d->query($sql); $rs_province=$d->result_array(); $d->reset(); $sql="select * from #_district where provinceid='".$province."' order by districtid"; $d->query($sql); $rs_district=$d->result_array(); ?>