fetching the last inserted row from mysql

[pahikua]

I have a site where a user can sign up etc etc. On the front page I want to display the last user who has signed up. How can I do this. I have a datetime field in the database that holds the time the signedup at. Can I use that to grab that most recent date or is it better to do it another way. Any help is much appreciated.

Mahalo,
Mike

[acidbox]

$sql = "SELECT username FROM table ORDER BY date_joined DESC LIMIT 0, 1";

[pahikua]

thanks, that did it

Mike