LAST_INSERT_ID() into variable

[camcim]

Hi all,
If i am using the following query:

$sql_query ="INSERT INTO movie_genre (movie_id, genre_id) VALUES (LAST_INSERT_ID(),'$genre_id')";
$result = mysql_query($sql_query);

how can i make the LAST_INSERT_ID() a variable? (inorder to use it later)

Cheers,
camcim

 

[sleipnir214]

$foo = mysql_insert_id($result)

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!