First off, thank you Miguel and Nathan for responding.

The ordering changes.  Here is what I have for my query:
                 $searchStmt="Select * from $temp2 where sea_id = '$sea_id' 
order by pts DESC";
                 if($aa){$searchStmt .= ",$aa DESC";}
                 if($bb){$searchStmt .= ",$bb DESC";}
                 if($cc){$searchStmt .= ",$cc DESC";}
                 if($dd){$searchStmt .= ",$dd DESC";}
                 $searchStmt .= ",name ASC";

$aa, $bb, $cc and $dd will change depending on how the division does their 
ranking.  For the most part, I can sort with the mysql query as 
above.  There is one variable that can't be sorted (at least I was told it 
can't), by this query.  If there is a tie, I have to check to see if the 
teams have played each other and if they have, than whomever won that game 
will be ahead in the rankings.
         Nathan, on this list, suggested using a loop for this.  I am not 
that proficient in PHP to do that.  I could probably do that if there would 
only be two teams that might be in a tie, but you actually can have 
multiple ties for positions and/or more than 2 teams tieing for one 
position.  I have to program with the possibility that all teams can tie 
and than it has to loop through and get the games by who won in a one on 
one game.


At 04:03 PM 4/25/2002, Miguel Cruz wrote:
>On Thu, 25 Apr 2002, Steve Buehler wrote:
> > I am using PHP to access a mysql database.  I was told that what I need to
> > do needs to be done in PHP and not mysql.  I can get mysql to order things
> > like this:
> > Select * from $temp2 where sea_id = '$sea_id' order by pts DESC
> > The problem is that if there is a tie (as in ranking 4 and 5 below), I 
> need
> > to run another query to check to see if something else has happened and if
> > it happened, than that team would be a higher rank than the other.  It is
> > possible to have more than 2 teams tieing too.  So I have to be able to
> > determine what order the teams should be in.
>Well, we don't know what the secondary sorting criterion is, but my guess
>is that you could have your database take care of that too in the same

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to