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
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
2 matches
Mail list logo