Page 1 of 1

Sort Alphabetically

Posted: Sun Mar 22, 2009 3:41 pm
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!

Re: Sort Alphabetically

Posted: Sun Mar 22, 2009 3:43 pm
by Inkyskin
Read up on ORDER BY

Code: Select all

$query = "SELECT * FROM phpbb_profile_fields_data ORDER BY pf_surname";

Re: Sort Alphabetically

Posted: Tue Mar 24, 2009 10:08 am
by anabeli
Great, thanks a lot for your quick response! I'm new to PHP programming!