PHP PouleTeam::getAllFromQuery Examples

Example #1

File: Team.php Project: rjpijpker/nefub-mobile

 public function getPouleTeams()
 {
     $query = "SELECT PouleTeam.id\n\t\t\t\t\tFROM PouleTeam \n\t\t\t\t\tWHERE team_nefub_id = '" . $this->nefub_id . "'\n\t\t\t\t\tGROUP BY poule_nefub_id\n\t\t\t\t\tORDER BY team_nefub_id ASC";
     return PouleTeam::getAllFromQuery($query);
 }

Example #2

File: Poule.php Project: rjpijpker/nefub-mobile

 public function getPouleTeams()
 {
     $query = "SELECT PouleTeam.id FROM PouleTeam\n\t\t\t\t\tLEFT JOIN Team ON PouleTeam.team_nefub_id = Team.nefub_id\n\t\t\t\t\tWHERE PouleTeam.poule_nefub_id = '" . $this->nefub_id . "'\n\t\t\t\t\tGROUP BY Team.nefub_id\n\t\t\t\t\tORDER BY PouleTeam.ranking ASC, Team.name ASC\n\t\t\t\t\t";
     return PouleTeam::getAllFromQuery($query);
 }