"Barry Rumsey" <[EMAIL PROTECTED]> wrote on 4/21/2002 4:58:21 AM:
>
>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()?
if you'd think that your queries is correct, try use some sort of different identifier
for each
query. and also look at mysql_error, as this very useful to determine what's wrong.
$query1 = mysql_query("INSERT INTO music_album VALUES
(NULL, '$artist_id' ,'$album' ,NULL ,NULL)");
if(!$query1) {echo "error query 1 mysql_error()"; }
$query2 = mysql_query("INSERT INTO music_songs VALUES
(NULL ,NULL ,NULL ,NULL ,'$songname' ,'$lyrics')");
if(!$query2) {echo "error query 2 mysql_error()"; }
CMIIW
_________________
adi.baliroomfinder.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
