Ususally when someone needs to select last row in a table (s)he do:
select * from some_table order by some_field desc limit 1;
but there is another possible solution for mysql :
mysql_free_result(mysql_query('select @a:=max(member_id) from memberInfo'));
$res=mysql_query('select * from memberInfo where member_id=@a;');

More info here :

Andrey Hristov

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to