[UPHPU] Dual ID numbers

Timothy Humphrey timothy.humphrey at gmail.com
Tue Jun 7 10:26:16 MDT 2005


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.



More information about the UPHPU mailing list