Another question for Magic (or any other PHP Programmer)

[puggy]

are there any id's in the table?
Normally the first thing i add in a table is an id, that way i can find specific info. So in this case i would just use:

$query = "select * from users WHERE id='1' ";

if you adding into the DB table, to get the next id you can:

$query = "select MAX(id) from users";

then add 1 to that id

[Magicfinger]

$sql=(SELECT * FROM users LIMIT 2 ORDER BY id DESC);

and to count the users

$numusers=mysql_query(SELECT COUNT (*) FROM users);