Ltj_bukem Posted November 28, 2007 Share Posted November 28, 2007 Hi, I have a table that counts how many times a document has been downloaded, this is works fine but I'd like to do a query that would display the top ten downloaded documents. I imagine it would be something like query = "SELECT FROM docs........ Cheers Quote Link to comment Share on other sites More sharing options...
trq Posted November 28, 2007 Share Posted November 28, 2007 SELECT fld FROM doc ORDER BY fld DESC LIMIT 10; Where fld is the name of the field containing your counts. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.