[RESOLVED] Displaying last record in table

[Jermizzle]

I have a table which records name and date a user submits a rating.
I want the last record to be displayed when viewing the results table.

I had a stab at it and used

while ($row=mysql_fetch_assoc($select_rater)){
echo "Rating: last updated by ".$row['rater'] " - " .$row['date']";
}

I also tried

echo "Rating: last update by $rater - $date";

&

echo "Rating: last update be &_POST[rater] - $date";

but nothing appears.

This displays the desired data, but i have 6 names in the rater table so text appears 6 times when i want it to display the recent rater without showing the past raters. Is there a something i have to add so only the last row in the table is displayed.

date is not built through a form, the variable is set outside of the form, but still displays the correct date so thats fine.

Thanks

[laserlight]

Order by the date in reverse and select the first record (i.e. use LIMIT 1).

[Jermizzle]

Thanks, got it sorted now 🙂