r 28, 2003 19:05
Subject: Re: [PHP-DB] mysql, finding the last record
> For the last Auto-increment
> SELECT LAST_INSERT_ID() FROM tblName;
>
> For the last row data:
> SELECT col1, col2, col3, col4 FROM tblName ORDER BY SortedColumn
> LIMIT 1
>
> I don'
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
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
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
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
