Jump to content


Photo

Sorting help


  • Please log in to reply
1 reply to this topic

#1 corvyr

corvyr
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 06 March 2006 - 05:09 PM

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.

#2 mem0ri

mem0ri
  • Members
  • PipPipPip
  • Advanced Member
  • 110 posts

Posted 06 March 2006 - 05:44 PM

[!--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) View Post[/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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users