| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)standraise.com/sc/ |
Upload File : |
<div class="customGroup">
<?
load(0, 0, 1);
function load($p, $space, $top)
{
/*$sql = "SELECT * ";
$sql .= "FROM productcat ";
$sql .= "where parentid = $p ";
$sql .= "order by sortby";*/
$sql = " select p.productcatid, sum(i.productimageid) as num, p.productcatnamesc";
$sql .= " from productcat p left join productimage i on p.productcatid = i.productcatid";
$sql .= " where p.parentid = $p ";
$sql .= " group by p.productcatid, p.productcatnamesc ";
$sql .= " order by p.sortby";
$result1 = mysql_query($sql);
$n=1;
$count = mysql_num_rows($result1);
$num = mysql_num_rows($result1);
if (($top<>1) && ($num > 0))
{
echo "<ul>";
}
while ($row = mysql_fetch_array($result1,MYSQL_ASSOC))
{
if ($top==1)
echo "<div class='customGroup_title'>";
else
echo "<li>";
if ($row{'num'} <> '')
echo "<a href='product.php?page=product.php&productcatid=".$row{'productcatid'}."'>". $row{'productcatnamesc'} . "</a>";
else
echo $row{'productcatnamesc'};
//echo "<a href='product.php?productcatid=".$row{'productcatid'}."'>". $row{'productcatname'} . "</a>";
if ($top==1)
echo "</div>";
else
echo "</li>";
load($row{'productcatid'}, $space+1, 2);
}
if (($top<>1) && ($num > 0))
{
echo "</ul>";
}
}
?>
</div>