|
-
Jul 6th, 2004, 03:37 AM
#1
Finding the 5 last dates... [Resolved]
I have to find exactly 5 records in a MySQL database. And it have to be the 5 with "highest" dates. They are not in the right order at all. So I have to sort them some way, and the problem is that I have to show the oldest of the 5 newest first and then the newest of the newest last.
Anyone have any idea on how to do this?
PS: I tried to take out the 5 newest one first and save the rows in diffrent variables. But since I am going in and out of PHP mode it looks like my variables are lost. So the best way would probably be if the MySQL querrery only took out the 5 newest and sorted them from the oldest to the newest.
Last edited by NoteMe; Jul 8th, 2004 at 10:02 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote