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