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

2003-09-28 Thread Director General: NEFACOMP
t know what you are looking for exactly. > Explain and we will try to help though I am not an expert. > > > Thanks > Emery > - Original Message - > From: "Joe Nilson Zegarra Galvez" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday,

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

2003-09-28 Thread Director General: NEFACOMP
hanks 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

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 pre

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