corvyr Posted March 6, 2006 Share Posted March 6, 2006 I'm pretty new to PHP and I'm wondering how I would sort a table using 2 different fields, for example sorting by age and then by name. Quote Link to comment Share on other sites More sharing options...
mem0ri Posted March 6, 2006 Share Posted March 6, 2006 [!--quoteo(post=352105:date=Mar 6 2006, 09:09 AM:name=Aaron Korr)--][div class=\'quotetop\']QUOTE(Aaron Korr @ Mar 6 2006, 09:09 AM) [snapback]352105[/snapback][/div][div class=\'quotemain\'][!--quotec--]I'm pretty new to PHP and I'm wondering how I would sort a table using 2 different fields, for example sorting by age and then by name.[/quote]Sorting tables works best through SQL statements if you're using a database.$query = "SELECT * FROM users ORDER BY name ASC, age DESC";$qresult = mysql_query($query);while($row = mysql_fetch_array($qresult)){ qarray[] = $row;}...qarray will then be an array filled with your sorted values from the database. The SQL statement sorts first by name in ascending (ASC) order...or A-Z...and then by age in descending (DESC) order...or oldest to youngest. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.