Best way to order mysql results with limit

[Reinhart Viane]

Hey list I have a table like this:   Act_name       Act_type_id      Act_date Heyhey             1                      22-06-05 Aloha                2                      22-06-05 Tralala               2                      22-06-05 Wuhu                1                      22-06-05 Hehe                 3                      22-06-05 Olalal                3                      22-06-05 Pompom           1                      22-06-05 Wuhu                2                      22-06-05   Now i want to do a select which returns the two most near (in the future) activities of each act_type_id     Is there a way to do this cleanly or should I better do a full select and only get what I want with php?   Thx in advance.   Btw I’m using MySQL 4.0.1-alpha-nt       Reinhart Viane D-studio [EMAIL PROTECTED]   Graaf van Egmontstraat 15/3 – 2800 Mechelen Tel: +32 (0)15 448 901     STRICTLY PERSONAL AND CONFIDENTIAL This message may contain confidential and proprietary material for the sole use of the intended recipient.  Any review or distribution by others is strictly prohibited.   If you are not the intended recipient please contact the sender and delete all copies.

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]