On 6/4/2006, "Pete" <[EMAIL PROTECTED]> wrote:

>
>
>
>In message <[EMAIL PROTECTED]>,
>Mike Franks <[EMAIL PROTECTED]> writes
>> and you should never base
>>any query or sorting logic on the key - it should only be used to fetch
>>a particular record.
>
>I think that this sounds a little confusing, and I don't think that I
>agree with you here. 

You're right, Pete, not only confusing, but inaccurate. What I should
have said was you should never query for min() or max() on an
auto_increment'd key value and assume it implies anything about when
the record was created. Likewise, you should never sort or perform any
other decision based on auto_increment'd values. They are simply unique
key values and should only be used as described in your next paragraph:

>If the records refer to students in a class, you
>can use the student number for various things, (but you wouldn't
>renumber all the students if one left!).  But you could use the key ID
>to find the student, or to attach the student to courses, or check the
>students account, etc.
>


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list




SPONSORED LINKS
Php mysql Job postings


YAHOO! GROUPS LINKS




Reply via email to