Re: [PHP-DB] mysql, finding the last record

2003-09-28 Thread Director General: NEFACOMP
Emery - Original Message - From: Joe Nilson Zegarra Galvez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 26, 2003 19:38 Subject: Re: [PHP-DB] mysql, finding the last record if you are seeking for the last in autoincrement field, in your select use this: select max(field

Re: [PHP-DB] mysql, finding the last record

2003-09-28 Thread Director General: NEFACOMP
though I am not an expert. Thanks Emery - Original Message - From: Joe Nilson Zegarra Galvez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 26, 2003 19:38 Subject: Re: [PHP-DB] mysql, finding the last record if you are seeking for the last in autoincrement field

[PHP-DB] mysql, finding the last record

2003-09-26 Thread John Ryan
is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id prefer an elegant solution. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql, finding the last record

2003-09-26 Thread Jason Wong
On Saturday 27 September 2003 01:04, John Ryan wrote: is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id prefer an elegant solution. mysql_num_rows() mysql_data_seek() -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] mysql, finding the last record

2003-09-26 Thread Joe Nilson Zegarra Galvez
if you are seeking for the last in autoincrement field, in your select use this: select max(field) from table; if is other, well, i dont remember :D Regards Nilson John Ryan dijo: is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id