0 AND (name LIKE \"%$value%\" OR alias LIKE \"%$value%\")"; $ord = "pid"; $ordname = "未指定"; if($ordertype != ""){ switch($ordertype){ case "price": $ord = $global_tprice; $ordname = "价格"; break; case "ondate": $ord = "ondate"; $ordname = "日期"; break; case "soldcount": $ord = "soldcount"; $ordname = "销量"; break; case "viewcount": $ord = "viewcount"; $ordname = "浏览量"; break; default: $ord = "pid"; $ordname = "编号"; } } $des = ""; $desname = "升序"; if($orderdesc){ $des = "DESC"; $desname = "降序"; } $findcount = 0; $arr_col = array(); $arr_col_count = array(); $i = 0; foreach($array_column as $tkey => $tval){ $columnid = $tkey; $tableproduct = $array_column["$columnid"][2]; $qry_string = "SELECT COUNT(*) FROM $tableproduct WHERE $cond"; $result = $db_query($qry_string, $mySQL_ID) or mysql_die(); $row=$db_fetch_array($result); $arr_col[$i] = $columnid; $arr_col_count[$i] = $row[0]; $findcount += $row[0]; $i ++; } $lineperpage = 30; $linecount = $findcount; $pagecount = intval(($linecount+$lineperpage-1)/$lineperpage); if($page <= 0) $page = 1; if($page > $pagecount) $page = $pagecount; $startline = ($page - 1) * $lineperpage; $sum = 0; $i = 0; $sum2 = 0; while($sum < $startline){ $sum += $arr_col_count[$i]; $sum2 += $arr_col_count[$i]; $i ++; } if($sum == $startline){ $start_col_index = $i; } else{ $start_col_index = $i - 1; $sum2 -= $arr_col_count[$start_col_index]; } $linkstr = "检索到$linecount个产品 "; $linkstr .= "关键字:$value|排序:$ordname $desname"; $pagelink = "第 $page 页/共 $pagecount 页"; if($page>1){ $pagelink .= "[首页] [上一页]"; } if($page<$pagecount){ $pagelink .= " [下一页] [末页]"; } ?>
电视剧 | 电影
卡拉OK | 百科
大陆歌手 | 港台歌手
日韩歌手 | 群星合辑
乐队组合 | 劲爆舞曲
影视音乐 | 乐器欣赏
经典音乐 | 中国民乐
生活时尚 | 人物传记
少儿读物 | 电脑网络
烹饪饮食 | 英语学习
工商管理 | 励志精品
流行小说 | 人文社科
散文诗词 | 卡通漫画
中外名著 | 休闲娱乐
套装系列
珍珠饰品 | 中国字画
中国香烟 | 毛绒玩具
美中卓越 | 加中枫华
全球通 | 勿忘我
喜马拉雅
抗衰老 | 抗氧化
维他命 | 卵磷脂
花旗参 | 性保健
深海鱼油 | 男性保健
女性保健 | 老年保健

0 && $start_pos){ $db_data_seek($result,$start_pos); } } while(($rows=$db_fetch_array($result)) && $retrived_line ++ < $lineperpage){ $p_pid = intval($rows['pid']); $p_name = $rows['name']; $p_alias = $rows['alias']; $p_status = $rows['status']; $p_orders = $rows['orders']; $p_rank = $rows['rank']; $p_viewcount = $rows['viewcount']; $p_soldcount = $rows['soldcount']; $p_ondate = substr($rows['ondate'],0,10); $p_description = cutstr(stripslashes($rows['description']),120); $p_lphotoname = $rows['lphotoname']; $p_mphotoname = $rows['mphotoname']; $p_sphotoname = $rows['sphotoname']; $storage = intval($rows['storage']); $p_photo = $dir."/".$p_sphotoname; $p_mprice = sprintf("%.2f",$rows["$global_mprice"]); $p_tprice = sprintf("%.2f",$rows["$global_tprice"]); $price_dif = sprintf("%.2f",$rows["$global_mprice"] - $rows["$global_tprice"]); if($price_dif > 0 && $p_tprice > 0){ $price_dif_rat = sprintf("%0d",$price_dif/$p_tprice * 100); } $p_typeid = $rows['typeid']; $pid = $columnid * 1000000 + $p_pid; //$cart_str = ($storage > 0)?"订购":"脱销"; $cart_str = ($storage > 0)?"订购":"脱销"; $j ++; echo "
$j. $columnname >> $p_name
$p_description
US\$".$p_tprice." $cart_str  
"; } } ?>