Ranking....

[Anon]

I have a table where i insert records of sales what i want to do is to make a ranking to see who is the person who sales more things.

The problem is that i can't use order by because i want to sort the results once i have colected the data with a sql query.
Because i build the query like this:

select * from sales where saler = $saler_id and product like $product_id

so i can't sort that in the query.
Any idea?

Thanks

[Anon]

If you're going to order the results once you've collected them, then the order you receive them in from the database doesn't matter, does it? So go ahead and use ORDER BY ... LIMIT - it won't hurt anything, will it?

[Anon]

The problem is that i want to order the result in the page so the person with most sales is at the top......

[Anon]

Order by 'sales' ASC

at the end of the line place ASC or DESC. I think your bright enough to figure out which one you need! 🙂 Lata
Loaner