LIMIT actually does work quite well in this case. I have a few select queries that use LIMIT and ORDER BY in the same query.
Here is an example. SELECT * FROM maincount WHERE 1 ORDER BY totalcount DESC,name1 ASC,name2 ASC,name3 ASC,name4 ASC LIMIT 0,100 This is going to select the first 100 rows from the table maincount, and order by totalcount, then name1, name2, name3, and name4. It also works on different LIMIT values (such as 100,100, 200,100, 300,100, etc etc). Damien Heiser -----Original Message----- From: Piotras [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: Re: [midgard-user] Re: fetch n-th article from topic Axel Gebauer <[EMAIL PROTECTED]> wrote: > I would prefer an addition of two more arguments to the > mgd_list_topic_articles(): First article to return, and number of > articles to return, similar to "LIMIT" in SQL. I think this change > would be easy and assures the downward compatibility of the function. Easy , but not usefull. Mysql limit option will not work as You expect when used with "order by". Piotras --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
