|
08-25-2005, 11:50 PM
|
#1 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Sort by alternating authors? Is this possible with MySQL?
I have an article database with 5 different authors and hundreds of articles. Most authors have inserted their articles at one time. So if I sort by articleid it will tend to show the same author over and over.
I'd like to select 25 articles, but have the records show up like this: row1: article 1, author1 row2: article 2, author2 row3: article 3, author3 row4: article 4, author4 row5: article 5, author5 row6: article 6, author1 row7: article 7, author2 row8: article 8, author3 row9: article 9, author4 row10: article 10, author5 row11: article 11, author6 row12: article 12, author7 row13: article 13, author8 row14: article 14, author9 row15: article 15, author10 row16: article 16, author11 row17: article 17, author12 Is there a query that can sort this way? |
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import Access, Excel and data of other formats to MySQL by Navicat | NavicatGuy | Articles | 0 | 08-17-2004 01:08 AM |
| 3.2 Entering Queries | Administrator | Documentation | 0 | 06-09-2004 02:58 AM |
| 1.7 MySQL Information Sources | Administrator | Documentation | 8 | 06-08-2004 02:58 AM |
| 1.2.2 The Main Features of MySQL | Administrator | Documentation | 0 | 06-08-2004 01:55 AM |
| 1.2 Overview of the MySQL Database Management System | Administrator | Documentation | 0 | 06-07-2004 10:11 PM |
