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;'); $brr=mysql_fetch_array($res); mysql_free_result($res);
var_dump($brr); ?> More info here : http://www.mysql.com/doc/V/a/Variables.html Regards, Andrey Hristov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]