PHP sql各种查询语句.docVIP

PHP sql各种查询语句 查询广告 ? $sql=select ad_name,ad_http,ad_pic1,ad_text from .$db_web_ad. where ad_id=4 or ad_id=5 or ad_id=6; $db-query($sql); while($db-Next_Record()){ ? 查询栏目表 ? $sql=select title_id,title_name,remark from .$db_web_title. where title_id=2; $db-query($sql); $db-Next_Record();{ ? 广告查询 简易: ? $ls_ad_id=2;include(syd/php/index/index_gg.php);? 查询分类 ? $sql=select type_id,type_name from .$db_put_ptype. order by type_id; $db-query($sql); while($db-next_Record()){ ? 查询 新闻 ? $sql= select title,update_time,auto_id,file_remark,is_top,first_picurl from .$db_web_file. where title_id=4 .order by auto_id desc.limit 0,4; $db-query($sql); while($db-Next_Record()){ ? //新闻链接 字符 file.php?tt_id=4ts_id=22 循环查询新闻 ? $sql = select title,auto_id,update_time from syd_title_con where title_id=9 order by auto_id desc limit 6; $db-query($sql); while($db-next_Record()){ $id = $db-Record[auto_id]; $title = $db-Record[title]; $time = substr($db-Record[update_time],0,-6); ? lia href=file.php?ts_id=? echo $id;? title=? echo $title;? target= nbsp;? echo $title;?/aspan? echo $time;?/span ? }? 内页各页面的banner图片 ? if($pub_title_index_pic!=){? img src=? echo $pub_title_index_pic;? width=898 height=164/ ? }else{? img src=images/list_pro_banner.jpg width=898 height=164 / ? }? 内页 判读 ? if($pub_title_content!=){ echo $pub_title_content; }else{ include( syd/php/title/title_list.php); } ? 搜索产品 form action=product.php?weblan=? echo $weblan? method=post input type=text name=product_name value=Search class=inde/input type=submit class=sercss_input2 value= /form 分类连接 product.php?type_id= foot 页面查询 ? echo $pub_web_copy_right;? 产品 显示多少字符 ? echo sub_string($db-Record[product_name],20,...,0);? 产品查询. $sql=select pt_logo from .$db_put_product. where product_id=.$