";
//get all categories
$query = "SELECT * FROM categories ORDER BY categoryID";
$categories = $db->query($query);
/*
foreach ($categories as $category) :
echo $category['categoryID']."
";
echo $category['categoryName']."
";
endforeach;
*/
$query = "SELECT * FROM categories WHERE categoryID = $category_id";
$category = $db->query($query);
$category = $category->fetch();
$category_name = $category['categoryName'];
//echo $category_name."
";
$query = "SELECT * FROM products WHERE categoryID = $category_id ORDER BY productID";
$products = $db->query($query);
/*
foreach ($products as $i) :
echo $i['productCode']."
";
echo $i['productName']."
";
echo $i['listPrice']."
";
echo $i['productID']."
";
echo $i['categoryID']."
";
endforeach;
*/
?>
My Guitar Shop