Hi,
I have a sliding menu on this page:
http://www.freemanholland.com/cow/public_html/shop
If you look on the left you will see the sliding menu when clicking on a main link.
Now what i need to do is pull this out dynamically from a database. I have the following tables:
tbl_main_category
ID, name, date_added, deleted
tbl_category
ID, name, maincategory_ID, date_added, deleted
tbl_subcategory
ID, name, category_ID, date_added, deleted
So,
- Main Categories are “Men” and “Women”
- Categories are “Clothing”, “Shoes” etc…
- Sub categories are “Coats and Jackets”, “Knitwear” and so on…
Now i have the following methods in place:
class Category {
public function selectAllMainCategories(){
$query = "SELECT * FROM tbl_maincategory WHERE deleted = 0";
$result = mysql_query($query);
return $result;
}
public function selectAllCategories(){
$query = "SELECT c.ID as TheID,
c.name as TheName,
c.maincategory_ID,
c.date_added,
m.name
FROM tbl_category c
INNER JOIN tbl_maincategory m
ON c.maincategory_ID = m.ID
WHERE c.deleted = 0 AND m.deleted = 0
ORDER BY c.date_added DESC";
$result = mysql_query($query);
return $result;
}
public function selectAllSubCategories(){
$query = "SELECT s.ID as TheID,
s.name as TheName,
s.category_ID,
s.date_added,
c.name
FROM tbl_subcategory s
INNER JOIN tbl_category c
ON s.category_ID = c.ID
WHERE s.deleted = 0 AND c.deleted = 0
ORDER BY s.date_added DESC";
$result = mysql_query($query);
return $result;
}
public function selectAllSubcategoriesByCategoryID($ID){
if(is_numeric($ID)){
$query = "SELECT s.ID as TheID,
s.name as TheName,
s.category_ID,
s.date_added,
c.name
FROM tbl_subcategory s
INNER JOIN tbl_category c
ON s.category_ID = ".mysql_real_escape_string($ID)."
WHERE s.deleted = 0 AND c.deleted = 0";
$result = mysql_query($query);
return $result;
}else{
die('ID needs to be numeric');
}
}
}
How can i put this together to create the menu how i want…
I understand that these methods may need to change, so i appreciate any help whatsoever…
Thanks
