[GLLUG] mysql help

[Mike Szumlinski]

do you have a serial number that is sequential or a date stamp?  You can 
always pull by doing something like this if you do:

select <attributes> from <table> order by <datestamp/serial> desc limit 1

the desc makes the query descending, so the last datestamp or serial 
(your most recent entry or "last row") is pulled first.  The limit 1just 
pulls whatever you want from that row. Hope this helps (I'm just geeked 
I can finally start helping someone else instead of being the helpee all 
the time)

-Mike

On Thursday, June 27, 2002, at 03:02 PM, Adam Kendall wrote:

> something like...  SELECT last_row FROM $table  or SELECT * FROM $table
> WHERE last_row