[thelist] SELECTing and auto_increment field

Jackson Miller anything at jaxn.org
Thu Sep 13 18:04:15 CDT 2001

My solution was to use a separate, two-column table that contains the id of
the last record edited, and the name of the table it comes from. I update
that last_id field at the end of every INSERT or UPDATE. Then I select it
using the appropriate table name whenever I need to refer to it. Seems
convoluted, but it works.

Is there a simpler solution? I did rtfm, but didn't find anything.

Why not just add a column of the timestamp type.  It will automatically
adjust the value any time the field is updated (or inserted).  Then you just
search for the most recent time.

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

More information about the thelist mailing list