Hi guys,
I have a problem sorting values comming out of a db. It is not as easy.
Here is the prob:
One table containing user points.
Other table containing reports with rankings
For each top 10 report (the 10 reports with the most ranking) there are 20
extra points granted
Now I would like to get the top 5 members out of the db. If I only pull out
the user table ordered by points desc limit 5 I might miss a user with a top
10 report and 20 extra points.
So I thought about sorting the array afterwards with asort, but then I loose
the asoziation with the user_id.
Maybe there is a way to sort the other arrays with the same sorting algo? Or
a way to include a iff clause in the query?
currently I am doing:
SELECT
u_name,
id,
points
FROM user
WHERE
points > 0
ORDER by points desc
LIMIT 5
and the top10 reports extra.
Has anybody a good idea on that?
Andy
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
