catalog.php

这个版本只是修正了一些BUG

<?php
/****************************************************
    	catagory.php - 商品目录程序

	Version  : 1.2
	Author   : Nnaqing ([e-mail])
	Copyright:
	Writed   : 2003/08/08
	Modified : 2004/11/09
*****************************************************/

require "./include/base.php";
require "./include/catalog.php";
//$nav .= SEPARATER.$language['wtitle_catagory'];

$tablelist = array();
$largesort = array();
if(isset($sortid))
{
	$sortid=intval($sortid);
	$sqlstr="select sortid, class, sortname, supsortid,remarks from $table_sorts where sortid=$sortid order by displayorder";
	$query=$db->query("select sortid,sortname  from $table_sorts where sortid=$sortid");
	if ($dbq_rec = $db->fetch_array($query))
	    $sortname=$dbq_rec['sortname'];
	$nav .= SEPARATER."<a href='catalog.php'>".$language['nav_catalog']."</a>";
	$nav .= SEPARATER.$sortname;
	unset($query);unset($dbq_rec);
}
else
{
	$sqlstr="select sortid, class, sortname, supsortid,remarks from $table_sorts order by displayorder";
	$nav .= SEPARATER.$language['wtitle_catagory'];
}
$query = $db->query($sqlstr,1);
$tablelist =getsortlist($query);
/*while($dbq_rec = $db->fetch_array($query)) 
{
	$sortid=$dbq_rec['sortid'];
  	$tablelist[] = $dbq_rec;
  	$query1 = $db->query("SELECT * FROM $table_sorts WHERE supsortid = $sortid order by displayorder");
  	while($dbq_rec1 = $db->fetch_array($query1))
  	{
   		$sortid=$dbq_rec1['sortid'];
   		$query2 = $db->query("SELECT COUNT(*) FROM $table_products WHERE sortid = $sortid");
  		$dbq_rec1['productnum']=$db->result($query2,0);
   		$sub_sort="";
   		$query2 = $db->query("SELECT * FROM $table_sorts WHERE supsortid = $sortid");
   		while($dbq_rec2 = $db->fetch_array($query2))
   		{
   		$sub_sort.="<a class=sort href='productdisplay.php?sortid=".$dbq_rec2['sortid']."'>".$dbq_rec2['sortname']."</a>&nbsp;&nbsp;";
   		$sortid=$dbq_rec2['sortid'];
   		$query3 = $db->query("SELECT COUNT(*) FROM $table_products WHERE sortid = $sortid");
  		$dbq_rec1['productnum']=$dbq_rec1['productnum']+$db->result($query3,0);
   		}
   		$dbq_rec1['subsort']=$sub_sort;
   		$tablelist[] = $dbq_rec1;
  	}

}
*/
$query = $db->query("SELECT count(*) from $table_products");
$productnum=$db->result($query,0);
$query = $db->query("SELECT count(*) from $table_sorts WHERE class=1");
$lsortnum=$db->result($query,0);
$query = $db->query("SELECT count(*) from $table_sorts WHERE class=2");
$sortnum=$db->result($query,0);
$query = $db->query("SELECT count(*) from $table_sorts WHERE class=3");
$ssortnum=$db->result($query,0);
include template('catalog');
?>