public static function getConferencesForTour($tour_id) { $conferences = array(); $result = mysql_query("SELECT conf_id, f_tour_id, name, type, date_created FROM conferences WHERE f_tour_id={$tour_id} ORDER by name"); if ($result && mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $conf = new Conference(); foreach ($row as $key => $val) { $conf->{$key} = $val; $conf->loadTeamIds(); } array_push($conferences, $conf); } } return $conferences; }