php help

[oprpg]

alright... so basically I have a user store script. I made a log for it, so that when someone buys an item from someone else it inserts a row into 'usl' with a column 'seller' as who they bought it from. I want to make a top 10 most popular user stores. How would i do that?

I tried doing "select * from usl ORDER by seller DESC LIMIT 10" but that won't work simply because it must select from multiple rows.

any suggestions?

[LordShryku]

Group them

  SELECT seller, count(*)
    FROM usl
GROUP BY seller
ORDER by seller DESC LIMIT 10

[oprpg]

how would I put that into queries?

would this work:

$variable = mysql_query("SELECT seller, count(*) FROM usl GROUP BY seller ORDER by seller DESC LIMIT 10");

[LordShryku]

Sure...try it.

You may want to alias the count though, if you're going to be using mysql_fetch_array to get the results.