Show latest mysql entry

[Maller]

I currently have a login script running, where the userdata is stored in a mysql database.
Now what i want to do is show the last registered user, aka. the username, but how can i extract this data from the mysql db ?

My tables looks like this:

CREATE TABLE users (
    username varchar(30),
    rname varchar(30),
    password varchar(30),
    email varchar(50),
    contry varchar(30),
    age varchar(10));

[_off_axis_]

you should add another field to your table called "date" or whatever you want and set it to DATETIME, then all you have to do to get the last registered user is

$query = mysql_query("SELECT * FROM users ORDER BY date DESC LIMIT 1");
while($row = mysql_fetch_array($query)){
echo "$row[username]";
}

hope this helps 🙂

[_off_axis_]

oh yeah, make sure when you insert the user into the database you insert the date using now() in the query

$insert_user = mysql_query("INSERT INTO users (username,rname,password,email,country,age,date) VALUES ('$username','$rname','$password','$email','$country','$age',now())");

[travelbuff]

you also really should have a user id field (uid) that is your primary key, is unique and auto incrementing. Please take a look at this article: http://www.phpbuilder.com/columns/tim20010110.php3