James Keeline wrote: > INSERT INTO players SET fname='Bill', lname='Smith', join=NOW(); > INSERT INTO registration SET uid=LAST_INSERT_ID, team='Reds', updated=NOW(); > > What I'm trying to illustrate here is that the second query uses > LAST_INSERT_ID > to hold the primary key value from the players table. More details on this in > the MySQL docs: > > http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html > James >
20080706 1206 GMT-6 Im just not getting back to this problem. I think I understand but Im not sure. These are my player values: 'fname', 'lname', 'address', 'city', 'state', 'zip', 'home', 'work', 'cell', 'email', 'contact_preference', 'gender', 'dob', 'ssl_dll', 'us_citizen', 'orgin_of_birth', 'goalie', 'experience', ); I insert them into players. Then I write: INSERT INTO registration SET uid=LAST_INSERT_ID, VALUES(NOW(); 'Fall2008'); I have never really understood the joins. Since I do not have a date on my players table, do I need one for the join=NOW(); or is this used outside of the table structure? Wade
