/**
* @param $id
* @return string
*/
public function getByBusiness($business_id)
{
$sql = "SELECT DISTINCT reuse_and_repair_db.Subcategory.subcategory_id, reuse_and_repair_db.Subcategory.subcategory_name FROM reuse_and_repair_db.Business\n INNER JOIN reuse_and_repair_db.Business_Subcategory ON reuse_and_repair_db.Business.business_id = reuse_and_repair_db.Business_Subcategory.fk_business_id\n \tINNER JOIN reuse_and_repair_db.Subcategory ON reuse_and_repair_db.Business_Subcategory.fk_subcategory_id = reuse_and_repair_db.Subcategory.subcategory_id\n WHERE reuse_and_repair_db.Business.business_id = ?\n \tORDER BY reuse_and_repair_db.Subcategory.subcategory_name;";
$prepared = $this->db->link->prepare($sql);
$prepared->bindParam(1, $business_id);
$success = $prepared->execute();
$all = $prepared->fetchAll();
foreach ($all as $row) {
$subcategory = new Subcategory($row['subcategory_id'], $row['subcategory_name']);
$this->results[] = $subcategory->jsonSerialize();
}
return $this->getJSON();
}
