Mark Hensler — Sat, 08 Dec 2001 00:03:18 +0000

ORDER BY section ASC, percent DESC

That should work. section=1 is people with over 5 games. section=0 is for people with under 5 games. So this will sort by section first (5+ games at top), then percentage (highest percent at top).

nike_guy_man — Fri, 07 Dec 2001 21:30:59 +0000

That works great
But what if a user has less than 5 games?
I want those with less than 5 games still at the end, and ordered by their percent... Should I simply order it by percent DESC after that?? (I forgot, %s should be descending as the best percent is the highest )

Mark Hensler — Fri, 07 Dec 2001 06:18:16 +0000

SELECT user, win, loss, percent, if((win+loss)>=5,1,0) as section
FROM table_name
ORDER BY section ASC, percent ASC

'In English: if the number of games is 5+, then 'section' will be 1, else 0. Then you sort on 'section' first to get the 5+ games at the top, then sort on 'percent' to get them ordered the way you want.

mySQL Docs:
6.3.1.4 Control Flow Functions (info on IF statements)

nike_guy_man — Fri, 07 Dec 2001 01:57:16 +0000

Actually, now that that has been brought up, win columns and loss columns would make this a lot easier
Should I simply add the results of win column and loss column together and if thats > 5, then order by %s...
Great!
I'll try all this out, and come back when I make a stupid mistake!
This should be my sql query, correct?

<?php
$sql = \"SELECT user, win, loss, percent FROM $table ORDER BY percent ASC \";
mysql_query($sql);
?>

Then how do I parse that into tables? a while loop?

Mark Hensler — Fri, 07 Dec 2001 00:09:54 +0000

I would have had a win field and a loss field... if you could change that now, that would be best.

If not, you could try something like this:

SELECT *
FROM table_name
WHERE ( SUBSTRING_INDEX(record, '-', 1) + SUBSTRING_INDEX(record, '-', -1) ) >= 5
ORDER BY percent ASC


SELECT *
FROM table_name
WHERE ( SUBSTRING_INDEX(record, '-', 1) + SUBSTRING_INDEX(record, '-', -1) ) < 5
ORDER BY percent ASC

'The first one should return people 5 games or over. The second should return under 5 games.

nike_guy_man — Thu, 06 Dec 2001 21:05:48 +0000

OK...
user password email record percent
user1 password1 user@random.net 4-1 80
user2 passworda user8@twf.com 4-6 40
user3 pass userpass@somewhere.net 3-0 100
user4 password user4@thenga.com 6-0 100
user5 password user5@thenga.com 1-2 67

I want it to count the total of the split record column, and if that is more than 5, order it by the percent column
So it would be ranked
user4
user1
user2
user3
user5

Even though user3 has a higher win percent, he hasn't competed 5 games so he doesn't qualify for the top position, unless no one else has any games played
Another thing, when I have users report that they lost, I want it to add 1 to the 2nd part of the record which I have split into the array $s so I want it to add 1 to $s[1], and add 1 to the opponents first part of record, which is $x[0]
However, when I run the script, it adds 1 to both $s[0] $s[1] and $x[0] and $x[1]
Any idea?

Mark Hensler — Thu, 06 Dec 2001 05:00:38 +0000

I'm a bit confused about that... can you make some mock data for us to see?