Problem INSERTing into table

[dbewick123]

HI, Im trying to insert into a table then return the last id then INSERT to another table using this id... here is the code, hopefully it makes more sense 

 

   mysql_query("INSERT INTO `books` ($fields1) VALUES ($data1)"); // query to insert the book     //data //into the database

               $lastId = mysql_insert_id();

 mysql_query("INSERT INTO `userBooks` `user_id`,`book_id` VALUES '$sessionUserId', '$lastId'");

 

Just to note the first query works perfectly, also user_id and book_id in the userBooks tables are foreign keys but that shouldnt make a difference. Please someone help.

Thanks in advance

Dbewick123

[gristoi]

mysql_query("INSERT INTO `userBooks` (`user_id`,`book_id`) VALUES ('$sessionUserId', '$lastId')");

 

you were missing the braces