ally.php

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

<?php
/***********************************************
    	ally.php -  公告程序

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2004/04/17
	Modified : 2004/04/17
************************************************/
require "./include/base.php";

//======= 取商品类别列表 ==================================================
$allylist=array();
$query = $db->query("select * from $table_sorts where class='group' order by sortid");
while($dbq_rec = $db->fetch_array($query))
{
   	$t_sortid=$dbq_rec['sortid'];
	$sortlist[]=$dbq_rec;
   	$query_1 = $db->query("select * from $table_sorts where supsortid = $t_sortid");
   	while($dbq_rec_1 = $db->fetch_array($query_1))
    	{
     		$t_sortid=$dbq_rec_1['sortid'];
   		//$sortlist[]=$dbq_rec_1;
   		$sub_line="";
   		$query_2 = $db->query("select * from $table_sorts where supsortid = $t_sortid");
   		while($dbq_rec_2 = $db->fetch_array($query_2))
    		{
     			$sub_line.="<a class=sort href='productdisplay.php?sortid=$dbq_rec_2[sortid]'>".$dbq_rec_2[sortname]."</a>&nbsp;&nbsp;";
     			//$sortlist[]=$dbq_rec_2; 
     			  	
    		}
    		$dbq_rec_1[subline]=$sub_line;
    		$sortlist[]=$dbq_rec_1;   	
    	}
}
unset($query);unset($dbq_rec);unset($query_1);unset($dbq_rec_1);unset($query_2);unset($dbq_rec_2);

$linknum=0;
$query = $db->query("SELECT * FROM $table_weblinks WHERE type = 'link'");
$linklist = array();
while($dbq_rec = $db->fetch_array($query))
{
  	$linklist[] = $dbq_rec;
  	$linknum++;
}
unset($dbq_rec);unset($query);

$allynum=0;
$allylist = array();
$query = $db->query("SELECT * FROM $table_weblinks WHERE type = 'ally'");
while($dbq_rec = $db->fetch_array($query))
{
    $allylist[] = $dbq_rec;
    $allynum ++;
}
unset($query);unset($dbq_rec);

$nav .=SEPARATER.$language['wtitle_ally'];
include template('ally');
?>