could you provide the table schema please? after all (apart from the fact that you may have conflicts with the autoincrement of the id row) your table is not normalized! create separate tables for albums *and* songs (and ...):
music_albums album_songs artists album_artist (table resolving the n:n relationship between music_albums and artists: one artist may play on several albums as well as one album may be recorded by more than one artist e.g. samplers) etc. steff Barry Rumsey wrote: > I have the following insert : > mysql_connect( "localhost", "xxxx", "xxxx" ); > mysql_select_db( "xxxx" ); > > mysql_query("INSERT INTO music_album VALUES > (NULL, '$artist_id' ,'$album' ,NULL ,NULL)"); > > mysql_query("INSERT INTO music_songs VALUES > (NULL ,NULL ,NULL ,NULL ,'$songname' ,'$lyrics')"); > > When I run this, the first insert works alright but the second insert > does nothing. What am I doing wrong ? > How do I do a mysql_insert_id()? > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php