[SOLVED] How can I retrieve data from a table based on the highest number in a field??

[Andy-H]

basically I want to retrieve 10 keywords from my database based on which ones occur most.

The db layout is:

 

--keyWords--

id (int)11 auto_inc primary_key

wordUsed (text). 

timesUsed (int)11

------

 

I think it has something to do with the max function but am not sure how to use it in the `Where` clause

 

Any help appreciated.

[fenway]

Don't mark it "solved" unless you've posted the solution for the beneift of others.

[Andy-H]

$query = "SELECT wordUsed FROM keyWords ORDER BY timesUsed DESC LIMIT 10";
$result = mysql_query($query);

while ($row = mysql_fetch_row($result)){

code;

}

 

[fenway]

Thanks!