[RESOLVED] Sorting out an array

[thegoldenchild]

Hi,

Im trying to make show the final 5 entries. So im running a query from my db, i can make them show all.

I run sort, arsort or any sort at the query, but it completely disapears or it doesn't work at all..

$query = "SELECT woonplaats FROM aanmelding"; 
$result = mysql_query($query) or die(mysql_error()."werkt niet 2");
$row = mysql_fetch_array($result, MYSQL_BOTH);

echo("<table><td><font size='2' face='arial' color='#000000'>" . $row['woonplaats'] . "</font></td>");

while ($row = mysql_fetch_array($result))
{   

echo ("<tr>
<td><font size='2' face='arial' color='#000000'>" . $row['woonplaats'] . "</font></td>
</tr>");

} 
echo("</table>");

[laserlight]

How do you define "final 5 entries"? By time of insertion? If that is the case, another column should be used to record the time of insertion, and this can be used in the query, e.g:

SELECT woonplaats FROM aanmelding ORDER BY t DESC LIMIT 5

where t is the time based column name.

[thegoldenchild]

Great thnx, it works...

Forgot i could sort with sql 🙂