Sort Alphabetically

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
anabeli
Forum Newbie
Posts: 2
Joined: Sun Mar 22, 2009 3:37 pm

Sort Alphabetically

Post by anabeli »

Hello,

How can I sort my resulting table alphabetically by $pf_surname?:


function getField($profile_data)
{
$db = mysql_select_db("idaworld_net")
or die ("Couldn't select database");
$query = "SELECT * FROM phpbb_profile_fields_data";
$result = mysql_query($query)
or die ("Couldn't exectute query");

/** Display results in a table **/
echo "<h1>Members</h1>";
echo "<table width='95%' align='center' cellspacing='0'>";
echo "<tr><td colspan='2'><hr /></td></tr>";
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n
<td><strong>$pf_surname&nbsp;$pf_first_name</strong></div></td>\n
<tr>\n
<td>$pf_inst_affil</td></tr>\n
<tr>\n
<td>$pf_town_city,&nbsp;$pf_country</td></tr>\n
<tr>\n
<td><em>Research interests:</em>&nbsp;$pf_research_int</td><tr>\n
<tr>\n
<td><em>Publications:</em>&nbsp;$pf_publications</td></tr>\n
<tr>\n
<td><em>Personal Webpage:</em>&nbsp;$pf_webpage</td></tr>\n";
echo "<tr><td colspan='2'><hr /></td></tr>\n";
}
echo "</table>\n";
}

Thanks for your help!
User avatar
Inkyskin
Forum Contributor
Posts: 282
Joined: Mon Nov 19, 2007 10:15 am
Location: UK

Re: Sort Alphabetically

Post by Inkyskin »

Read up on ORDER BY

Code: Select all

$query = "SELECT * FROM phpbb_profile_fields_data ORDER BY pf_surname";
anabeli
Forum Newbie
Posts: 2
Joined: Sun Mar 22, 2009 3:37 pm

Re: Sort Alphabetically

Post by anabeli »

Great, thanks a lot for your quick response! I'm new to PHP programming!
Post Reply