This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Sorting in MYSQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Sorting in MYSQL" Watch "Sorting in MYSQL" New topic

Sorting in MYSQL

Sehgal Amit

Joined: Dec 28, 2000
Posts: 2
How can we print the output retrived from the database in ascending or descending order in case of "MYSQL" on the basis of 2 fields(date & time).
For example :
Date: <%= date %>

Time: <%= time %>

To: <%= sendto %>

From: <%= sendfrom %>

Vernon Gibson
Ranch Hand

Joined: Dec 01, 2000
Posts: 35
I believe the answer to your question is to include an "Order By" clause in your query.
Good luck
It is sorta covered in the JavaRanch Style Guide.
subject: Sorting in MYSQL