[UPHPU] Dual ID numbers

Tyler Gee geekout at gmail.com
Tue Jun 7 10:31:40 MDT 2005


I guess I don't understand why you need that.  You could pull down all
the CDs for composer 2 sorted by unique ID (which could be 2, 7, 10,
14, 23) and they will still be in a certain order.

-wtgee

On 6/7/05, Timothy Humphrey <timothy.humphrey at gmail.com> wrote:
> Tyler Gee wrote:
> > Seems like you should have one table for composers and one table for
> > CDs, each with unique ids.  Then, in the CD table, link the composer
> > ID.
> 
> Right, that's on the right track; except that if I were to enter the
> first CD it would assign a "1", regardless of the composer. So, if I
> were to enter a second CD for a _different_ composer, it would assign
> "2", not "1".
> 
> What I need it to do is assign "1" for the second DB record, because it
> would be Composer 2, CD 1.
> 
> _______________________________________________
> 
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>




More information about the UPHPU mailing list