getRow($get_clients); return $results; } public function get_contacts($id) { global $database; $sql = " SELECT * FROM $db_name"."contacts WHERE location_id = '$id' LIMIT 1 "; $results = $database->getAll($sql); return $results; } public function get_locations() { global $database; $sql = " SELECT id, CONCAT(address,', ', suburb,', ', state,', ', post_code) AS name FROM clients_locations "; $results = $database->getAll($sql); $final_results = array(); foreach($results AS $result) $final_results[$result['id']] = $result; return $final_results; return $results; } public function get_all_locations($client_id) { global $database; $sql = " SELECT id, CONCAT(address,' ', suburb,' ', state,' ', post_code) AS name FROM clients_locations WHERE client_id = '$client_id' "; $results = $database->getAll($sql); $final_results = array(); foreach($results AS $result) $final_results[$result['id']] = $result; return $final_results; return $results; } public function get_location($location_id) { global $database; $sql = " SELECT CONCAT(address,' ', suburb,' ', state,' ', post_code) AS address FROM clients_locations WHERE id = '$location_id' "; $result = $database->getOne($sql); return $result; } } ?>