Im having trouble getting the new standings to show up
here is what I have
//Query Pacific //
$QueryPacific="SELECT * FROM QNHLProTeamV2 WHERE Division='$PacificDivision' ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC LIMIT 3";
$ResultPacific=mysql_query($QueryPacific);
$NumPacific=mysql_num_rows($ResultPacific);
//Query West Wild Card //
$QueryWestWildCard="SELECT * FROM QNHLProTeamV2 WHERE Conference='$WesternConference' ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC LIMIT 6,20";
$ResultWestWildCard=mysql_query($QueryWestWildCard);
$NumWestWildCard=mysql_num_rows($ResultWestWildCard);
//Query Est Wild Card //
$QueryEstWildCard="SELECT * FROM QNHLProTeamV2 WHERE Conference='$EasternConference' ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC LIMIT 6,20";
$ResultEstWildCard=mysql_query($QueryEstWildCard);
$NumEstWildCard=mysql_num_rows($ResultEstWildCard);
I can show top 3 of each division. my trouble is with the Wild card.
I was only able to show the Conference standings while skipping top 6 teams.
my problem is if a lower team from 1 division has more points then a top 3 team from the other division, the standings are incorrect
(www.qnhl.net) Canucks are there twice but Wild should be in the Wild card spot.
any ideas how I can fix this ?
( getting all my info fron STHS CSV files)
thanks
(PHP) need help with new NHL Standings..
Re: (PHP) need help with new NHL Standings..
Le seul moyen que je vois rapidement, c'est de sortir tes 6 équipes de divisions classés dans 6 variables et dans ta requête WILD CARD tu spécifie que `Team` ne doit pas être égale à ces 6 variables. La requête est plus longue mais ça devrait fonctionner
Re: (PHP) need help with new NHL Standings..
dans le genre
$QueryWestWildCard="SELECT * FROM QNHLProTeamV2 WHERE Conference='$WesternConference' AND Team != '$team1' OR Conference='$WesternConference' AND Team != '$team2' etc. jusqu'à 6 ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC
$QueryWestWildCard="SELECT * FROM QNHLProTeamV2 WHERE Conference='$WesternConference' AND Team != '$team1' OR Conference='$WesternConference' AND Team != '$team2' etc. jusqu'à 6 ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC
-
- The Addict / Le Drogué
- Posts: 752
- Joined: Fri Oct 28, 2005 2:42 pm
- Location: Ste-Julie
- Contact:
Re: (PHP) need help with new NHL Standings..
as-tu un example de ......Le seul moyen que je vois rapidement, c'est de sortir tes 6 équipes de divisions classés dans 6 variables
et merci Foo
et merci Foo
Re: (PHP) need help with new NHL Standings..
//Query Pacific //
$QueryPacific="SELECT * FROM QNHLProTeamV2 WHERE Division='$PacificDivision' ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC LIMIT 3";
$ResultPacific=mysql_query($QueryPacific);
$NumPacific=mysql_num_rows($ResultPacific);
ici exemple tu sors tes 3 équipes dans team1 team2 team3
$QueryPacific="SELECT * FROM QNHLProTeamV2 WHERE Division='$PacificDivision' ORDER by Points DESC, GP ASC, W DESC, GoalDiff DESC LIMIT 3";
$ResultPacific=mysql_query($QueryPacific);
$NumPacific=mysql_num_rows($ResultPacific);
ici exemple tu sors tes 3 équipes dans team1 team2 team3
-
- The Addict / Le Drogué
- Posts: 752
- Joined: Fri Oct 28, 2005 2:42 pm
- Location: Ste-Julie
- Contact:
Re: (PHP) need help with new NHL Standings..
ok c'est ce que j'ai ..j'etais juste pas sure comment faire le lien entre le Wild card et Team1 team2 et team3