Example #1
0
 /**
  * Get all catalog data with associated categories.
  * 
  * @return array
  */
 public static function getAllWithCatagories()
 {
     $Query = $GLOBALS['Database']->query("SELECT c.*, ct.name AS catagory, sbct.name AS sub_category \n            FROM " . static::$table . " AS c\n            LEFT JOIN " . Category::getTable() . " AS sbct ON sbct.id = c.category_id\n            LEFT JOIN " . Category::getTable() . " AS ct ON ct.id = sbct.parent_id");
     return $Query->fetchAll(\PDO::FETCH_OBJ);
 }