How do i Do Last user from mysql table?

[Gayner]

Like Newest user: _____

 

How do i Pull the newest user in my table, i know how to pull mysql but do i just LIMIT 1? lol

[oni-kun]

$query = mysql_query('SELECT Name FROM Table WHERE ID = (SELECT count(*) FROM Table)');

 

That should work to get last ID, you can echo the name of it.

[ngreenwood6]

if you are using an autoincrement id you could do:

 

$query = "SELECT * FROM users ORDER BY id DESC LIMIT 1";

 

The reason I did that is by doing it DESC you will get the last user and it will only return 1 result that way it doesnt go through all the users.

[ngreenwood6]

please do not use oni-kuns method and I will tell you why. Say you have 20 users in the database but maybe some of the other users were deleted leaving there id blank this would fail. The reason is say you had 25 registered but 5 were removed. the last id would be 25. Now if you used the method that oni-kun suggests it would select the count (or 20 in this case) as the id which would not be the correct id. Also that id might not even exist if it was one that was deleted.

[Gayner]

if you are using an autoincrement id you could do:

 

$query = "SELECT * FROM users ORDER BY id DESC LIMIT 1";

 

The reason I did that is by doing it DESC you will get the last user and it will only return 1 result that way it doesnt go through all the users.

 

sweet thank u

[GFXUniverse]

yes limit 1 as ngreenwood6 said

 

here is fully explained

<?php

$query = "SELECT * FROM users ORDER BY id DESC LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

$newest_member = $row['username'];
?>

Welcome to our newest member <?php echo $$newest_member; ?>