AW: [PHP-DB] multiple inserts

i think, your sql-statement isn´t correct. Maybe you don´t insert the right count of values, or you try to insert NULL in a "NOT NULL"-defined column. Try to "echo" the statement and run it with phpMyAdmin, wich will show you the position of your error in your statement. mysql_insert_id() gives you the insert-id of your last successfull INSERT. Tom > 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 >