SIGNUP LOGIN

Home Articles Content Writing Design General Internet Marketing Social Media Tools and Tips Usability Web Hosting Articles Tutorials AJAX Tutorials ASP Tutorials C# Tutorials CGI and Perl Tutorials CSS Tutorials Flash Tutorials HTML Tutorials Illustrator Tutorials Java Tutorials JavaScript Tutorials Linux Tutorials Miscellaneous Tutorials MySQL Tutorials Photoshop Tutorials PHP Tutorials Python Tutorials Wireless Tutorials WordPress Tutorials XML Tutorials Scripts AJAX Scripts ASP Scripts ASP.NET Scripts CGI & Perl Scripts Flash Scripts Java Scripts JavaScript Scripts PHP Scripts Python Scripts Remotely Hosted Tools and Utilities XML Scripts Answers Online Services Tools

Get Answers » Computer Programming Help » MySQL Help     How to do mysql query and have it ordered by two fields? Friday, 9th October 2009 by VistaXP I would like to sort my query results by two fields say with the first column having priority over the second one. Ask a Question Save Watch phpdreams SELECT * FROM my_table ORDER BY lastname, firstname ASC That will sort by both fields in ASCending order. You can also specify a direction for each order field as such: SELECT * FROM my_table ORDER BY lastname DESC, firstname ASC :o) Friday, 9th October 2009 Votes: 31 15 More MySQL Help: » How to publish a newsletter using PHP and MySQL? » How to get first letter of a field in MySQL? » How to make a simple image database ? » Backup MySQL Database » How to do nested select statements with MySQL?

Write For Us | Advertise with Us
Website Design by Ducani Media Group. Copyright ©2004-2013 NetVisits, Inc. All Rights Reserved. Privacy Policy.