public static function findProductCatagories($where, $join = []) { $sql = "SELECT base_product_id, product_catagory FROM base_product "; foreach ($join as $key => $value) { $sql .= "LEFT JOIN " . $key . " ON " . $value[0] . "=" . $value[1] . " "; } if (is_array($where)) { $sql .= $where['sql']; #echo "<br>" . $sql;die; $results = Model::buildAndRunPreparedStatement($sql, $where['datatypes'], $where['values']); return Model::createResultsArray($results); } else { $sql .= $where; $results = Model::runSql($sql); return Model::createResultsArray($results); } }