Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › ORDER BY DESCENDING command in Record Set Query

ORDER BY DESCENDING command in Record Set Query

Thread began 11/11/2009 3:29 pm by ijk76319396 | Last modified 11/11/2009 4:30 pm by ijk76319396 | 2070 views | 1 replies

11/11/2009 4:30 pmJustin Nemeth

Assuming you are using MySQL, using LIMIT will do what you want. The syntax is LIMIT [offset], [row count]. The offset starts counting at 0, so row 1 = 0, row 2 = 1, and so on.

So an example query that started at the 2nd row and returned 1 result would have:

SELECT * FROM table ORDER BY page_1 DESC LIMIT 1, 1

-justin

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.