I Need Show The Last Register User In PHP

[tutuyale]

I Need Show The Last Register User In menu.tpl

I Need Show The Last Register User In PHP, i have this table called " users " and have this rows "id" and " username " , but i want show in the menu.tpl the last registered user i have this code for the total of users:

<p><a><b><font color='red'>Total User: <?php $users = mysql_num_rows(mysql_query("SELECT SQL_CACHE * FROM ".TB_PREFIX."users")); echo $users; ?></font></b></a></p>

Please Dzoki help me!!!

 

[allycol93]

Something like:

$lastUser = mysql_fetch_assoc(mysql_query("SELECT * FROM ". TB_PREFIX . "users ORDER BY id DESC LIMIT 1"));

(i've not tested)

Maybe order by act time.

 

[tutuyale]

ok, but dont work for me, whem im put the code only show me this"Array", For whats?

 

[ronix]

ok, but dont work for me, whem im put the code only show me this"Array", For whats?

$lastUser = mysql_fetch_assoc(mysql_query("SELECT * FROM ". TB_PREFIX . "users ORDER BY id DESC LIMIT 1"));

simple!
add this code:

echo $lastUser['username'];

 

[tutuyale]

Wow, omg!!!! You are genious??? Thanks my friend, the post is closed xd!!!