[thelist] SQL Challenge Question

Javier Muniz jmuniz at granicus.com
Tue Oct 28 17:04:10 CST 2003


As a side note, you shouldn't use auto-increment fields.  Instead use
sequences.  Auto-increment is actually non-standard, whereas sequences can
be implemented on just about any database.  A sequence is a separate table
that tracks the last inserted id, the PEAR::DB module for PHP supports
sequences if you don't want to impelement them yourself, and is a great
resource/template if you do.

Cheers!

-Javier

-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com] 
Sent: Tuesday, October 28, 2003 8:38 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] SQL Challenge Question


[snip]
Version Tracking for a Project Tracking System. A user would add a project
blah. Then someone else down the line makes a change to the project, I want
to e-mail the owner the changes made. I just thought there was some really
neat way to do this with out a lot of if statements. [/snip]

If you are using an auto-increment number of some sort you could always get
the latest one via the highest auto-increment number.
-- 
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

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


More information about the thelist mailing list