$display_sub = "";
$cat_query = "SELECT DISTINCT categories.category_name, categories.category_id ";
$cat_query .= "FROM categories ";
$cat_query .= "ORDER BY categories.category_name ";
$cat_result = mysql_query($cat_query);
?>
if(mysql_num_rows($cat_result) == '0')
{
?>
}
else
{
while($firstRow = mysql_fetch_array($cat_result))
{
$cat = $firstRow['category_id'];
$category_name = getCategoryName($cat);
?>
|
= strtoupper($firstRow['category_name']) ?>
|
$sub_query = "SELECT subcategories.subcategory_id, subcategories.category_id, subcategories.subcategory_name ";
$sub_query .= "FROM subcategories ";
$sub_query .= "WHERE subcategories.category_id = '".$firstRow['category_id']."' ";
$sub_query .= "ORDER BY subcategories.subcategory_name ASC ";
$sub_result = mysql_query($sub_query);
if(mysql_num_rows($sub_result) == '0')
{
?>
}
else
{
while($display_sub = mysql_fetch_array($sub_result))
{
$query2 = "SELECT products.category_id, products.subcategory_id, products.product_id, products.product_item_number, products.product_name, products.product_price, products.product_description, ";
$query2 .= "products.product_picture_ext ";
$query2 .= "FROM products ";
$query2 .= "WHERE ((products.category_id = '" . $display_sub['category_id'] . "' ";
$query2 .= "AND products.subcategory_id = '" . $display_sub['subcategory_id'] . "') ";
$query2 .= "or (products.category_id2 = '" . $display_sub['category_id'] . "' ";
$query2 .= "AND products.subcategory_id2 = '" . $display_sub['subcategory_id'] . "')) ";
$query2 .= "AND products.product_home_flag = '0' ";
$query2 .= "ORDER BY products.product_id ASC ";
$result2 = mysql_query($query2);
if(mysql_num_rows($result2) == '1') {
$data2 = mysql_fetch_array($result2)
?>
|
= $display_sub['subcategory_name'] ?>
|
} else {
?>
|
= $display_sub['subcategory_name'] ?>
|
}
}
}
}
}
?>
|
|
|
|