echoing the last entry in a field

[thewomb]

hey im trying to echo the last entry in a the "id" in my database field..

i.e.

total members registered <? echo $last_id_member; ?>

how would i go about that?
thanx

[Drakla]

There are a couple of ways of going about it - if you want to find how many entries you have in a table do

select count(*) from sometable;

Which would be useful if there are any gaps in the table earlier on. If you just wanted the highest ID number you could use the MAX thing

select max(userID) from userTable;