Re: last row in the table

I wrote this because maybe the ordering is more expensive than 2 queries (one one indexed field possibly). Regards, Andrey ----- Original Message ----- From: "Andrey Hristov" <ahristov@icygen.com> To: <php-general@lists.php.net> Sent: Friday, December 21, 2001 5:18 PM Subject: [PHP] last row in the table > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >