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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
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]
