"") {
$arr_kind=split(",",$kind);
if (sizeof($arr_kind)==2) {
$subcategoryid=$arr_kind[1];
}elseif (sizeof($arr_kind)==1) {
$categoryid=$arr_kind[0];
}
}
//获得当前页码
if ($page==""){$vpage=1;}else{$vpage=$page;}
//获取搜索字符串
if ($prodname<>"") { $strSearch=$prodname;}
if ($lsearch<>"") { $strSearch=$lsearch;}
//确定显示内容SQL语句
$strsql="select * from pricelist where stop=0 and merchantid=$locationid ";
if ($subcategoryid<>"")
{
$strsql=$strsql." and subcategoryid = $subcategoryid ";
}
if ($manufacturerid<>"")
{
$strsql=$strsql." and manufacturerid = $manufacturerid ";
}
if ($strSearch<>"")
{
$strsql=$strsql." and (name like '%$strSearch%' or subcategoryname like '%$strSearch%' or brief like '%$strSearch%') ";
}
if ($fsubcategoryid<>0)
{
$strsql=$strsql." and subcategoryid=$fsubcategoryid";
}
if ($fname<>"")
{
$strsql=$strsql." and (name like '%$fname%' or subcategoryname like '%$fname%' or brief like '%$fname%') ";
}
if ($fstatus<>"")
{
$strsql=$strsql." and status like '$fstatus%'";
}
if ($fyear<>"")
{
$strsql=$strsql." and substring(time,1,4)=$fyear";
}
if ($fmonth<>"")
{
$strsql=$strsql." and substring(time,6,2)=$fmonth";
}
if ($fday<>"")
{
$strsql=$strsql." and substring(time,9,2)=$fday";
}
if ($fmanu_name<>"")
{
$strsql=$strsql." and manufacturername like '%$fmanu_name%'";
}
if ($fprov_name<>0)
{
$strsql=$strsql." and merchantname=$fprov_name";
}
$tmpsql=$strsql;
$strsql .= " order by time desc ";
$strsql=$strsql."limit ".($vpage-1)*$onepagelines.",".$onepagelines;
//获取打开的总行数
$tmprec=mysql_db_query($db,$tmpsql,$link);
if ($tmprec)
{
$totalrowsnum = mysql_num_rows($tmprec);
$rowplace = mysql_fetch_array($tmprec);
$merchantname = $rowplace[merchantname];
$subcategoryname = $rowplace[subcategoryname];
$trademark_name = $rowplace[trademark_name];
}
else
{
$totalrowsnum = 0;
}
//打开当前页显示内容纪录集
$rsPrice=mysql_db_query($db,$strsql,$link);
//获取当前报价时间
/*$strsql="select * from pricelist
where providerid=$locationid
order by time desc
limit 0,1";*/
$strsql="select max(time) as maxtime from pricelist where merchantid=$locationid";
$tmprec=mysql_db_query($db,$strsql,$link);
$strupdatetime = mysql_result($tmprec,0,"maxtime");
srand((double)microtime()*1000000); //生成广告随机数
$randval = rand();
srand((double)microtime()*1000000);
$randval1 = rand();
?>
即时报价
0)
{
$strsql = "select distinct manufacturerid,trademark_name from pricelist where trademark_name<>'' and subcategoryid=".$subcategoryid." and merchantid='$locationid' order by trademark_name";
//$strsql = "select id,name from manufacturer order by id";
$rec1=mysql_db_query($db,$strsql,$link);
$n=0;
while ($row1=mysql_fetch_object($rec1))
{
if ($row1->manufacturerid<>1)
{
if ($n%4==0)
{
echo "
