[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