include "./lib.inc.php";
include "head.inc.php";
include "left.inc.php";
//ºÐ·ù°¡Á®¿À±â
recursion_ca_id($ca_id, $whereStr);
$subject = $whereStr;
?>
Home echo $subject ?> |
|
// ÇÏÀ§ ºÐ·ù¸¦ Ç¥½ÃÇÑ´Ù.
$sql = " select ca_id, ca_name from $category_table where ca_sen_id = '$ca_id' order by ca_rank desc, ca_name, ca_id ";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result))
{
?>
while ($row = mysql_fetch_array($result))
{
echo "+ $row[ca_name] | ";
}
?>
} ?>
$sql = " select ca_id from $category_table where ca_sen_id = '$ca_id' order by ca_id desc ";
$result = mysql_query($sql) or die(mysql_error());
$classList = "";
while ($row = mysql_fetch_array($result)){
$classList .= $row[ca_id] . ",";
$sql_s2 = " select ca_id from $category_table where ca_sen_id = '$row[ca_id]' order by ca_id desc ";
$result_s2 = mysql_query($sql_s2) or die(mysql_error());
while($row_s2=mysql_fetch_array($result_s2))
$classList .= $row_s2[ca_id] . ",";
}
$classList .= $ca_id;
$total_sql = " select * from $item_table
where ca_id in ($classList) and it_rank >= 0 and it_sell_use ='Y' ";
$result = mysql_query($total_sql) or die (mysql_error());
$nTotalCount = mysql_num_rows($result);
$nPage = ceil($nTotalCount / $g_list_rows);
if (!isset($pg)) $pg = 1;
$nFrom = ($pg - 1) * $g_list_rows;
$sql = $total_sql . " order by it_rank desc, it_id desc limit $nFrom, $g_list_rows ";
$result = mysql_query($sql) or die (mysql_error());
$mod = 4;
if(!mysql_num_rows($result))
{
echo " \n";
echo "";
echo "¾ÆÁ÷ »óÇ°ÀÌ ÁغñµÇÁö ¾Ê¾Ò½À´Ï´Ù. | ";
echo " ";
echo " ";
}
else
{
echo "|
";
$i++;
echo " | ";
}
while($i%$mod!=0)
{
$i++;
echo " | ";
}
echo "
".pageListing($pg, $nPage, $g_list_rows, "./list.php?ca_id=$ca_id&pg=")." |
";
}
?>
|
include "tail.inc.php";
?>