| 中国产品平台 |
|
|
| 最新动态 |
$result=@mysql_query("SELECT id,DATE_FORMAT(pdate,'%m-%d') AS postdate,title,imgurl FROM drinknews where active='y' and newstype='n' and ptype!='0011' and ptype!='0014' and type<2 ORDER BY pdate DESC LIMIT 0,13");
$newstemp=0;
while($row=@mysql_fetch_array($result)){
$newstemp++;
if(strlen($row["title"])>100) $title1=msubstr($row["title"],0,100)."..";
else $title1=$row["title"];
echo "\n";
echo "| * ".$title1."\n ";
echo " ".$row["postdate"]." | \n";
echo " \n";
}
?>
|
| 产品展台 |
//网上展厅相关产品
?>
|
$t=0;
if ($class1!="") $sqljj="select id, title, image, content from drinkshow where active='y' and length(image)>10 and class1='$class1' and type='food group by memberid order by pdate DESC limit 0,3";
else $sqljj="select id, title, image, content from drinkshow where active='y' and length(image)>10 and type='food' group by memberid order by pdate DESC limit 0,3";
$resultjj=mysql_query($sqljj);
while($rowjj=mysql_fetch_array($resultjj)){
$t++;
//边框
//if (ceil($t%2=="1")) echo " | | ";
//if (ceil($t%2=="0")) echo " | ";
echo " | ";
?>
";
//if ($rowjj["image"]) printimg($rowjj["image"],120,93,"upload/drinkshow/",0);
if ($rowjj["image"]) echo " ";
else echo " ";
echo "";
?> |
|
echo msubstr($rowjj["content"],0,60);?>… [详细]
|
//if (ceil($t%2=="0")) echo " | ";
echo "";
}
?>
//网上展厅相关产品
?>
|
| 食品机械设备 |
//网上展厅相关机械产品
?>
|
$t=0;
if ($class1!="") $sqljj="select id, title, image, content from drinkshow where active='y' and length(image)>10 and class1='$class1' and type='machine' group by memberid order by pdate DESC limit 0,3";
else $sqljj="select id, title, image, content from drinkshow where active='y' and length(image)>10 and type='machine' group by memberid order by pdate DESC limit 0,3";
$resultjj=mysql_query($sqljj);
while($rowjj=mysql_fetch_array($resultjj)){
$t++;
//边框
//if (ceil($t%2=="1")) echo " | | ";
//if (ceil($t%2=="0")) echo " | ";
echo " | ";
?>
";
//if ($rowjj["image"]) printimg($rowjj["image"],120,93,"upload/drinkshow/",0);
if ($rowjj["image"]) echo " ";
else echo " ";
echo "";
?> |
|
echo msubstr($rowjj["content"],0,60);?>… [详细]
|
//if (ceil($t%2=="0")) echo " | ";
echo "";
}
?>
//网上展厅相关机械产品
?>
|
| 企业动态 |
$wysql=@mysql_query("SELECT id,DATE_FORMAT(pdate,'%m-%d') AS postdate,title,imgurl FROM drinknews where active='y' and newstype='n' and ptype='0011' and type<2 ORDER BY pdate DESC LIMIT 0,13");
while ($wy=mysql_fetch_array($wysql))
{
if(strlen($wy["title"])>22) $te=msubstr($wy["title"],0,22);
else $te=$wy["title"];
echo "| ·".$te." | ";
}
?>
|
|
0){
$page+=0;
if ($page<1) $page=1;
if ($page>$totalpages) $page=$totalpages;
?>
\n";
$tmplink.="\n";
$tmplink.=" | \n";
echo $tmplink;
$result=@mysql_query("SELECT id,DATE_FORMAT(pdate,'发布日期:%Y年%m月%d日') AS postdate,type,title,content,memberid,company,name,image FROM drinkbuysell ".$displaytype."ORDER BY pdate desc,id DESC LIMIT ".(($page-1)*$rowsperpage).",".$rowsperpage);
while($row=@mysql_fetch_array($result)){
if ($row["type"]=='s') $t1="| 【供应】 | ";
elseif ($row["type"]=='b') $t1="| 【求购】 | ";
else $t1="| 【合作】 | ";
$t1.="".$row["title"]." ";
$t2="".$row["postdate"]."";
if (strlen($row["content"])>100)
$t3=nl2br(htmlspecialchars(substr($row["content"],0,100)))."...";
else
$t3=nl2br(htmlspecialchars($row["content"]));
$t4="信息来源:";
if ($row["memberid"]) $t6=" ".logincompany($row["memberid"])."";
else $t6="";
$t5="详情请点...>> ";
?>
|
|
|
if ($row["image"]) printimg($row["image"],105,90,"upload/drinkbuysell/",2);
else echo " ";
?> |
|
| |
|
|
|
include("foot.php");
?> |