Return a value from an INSERT query in mysql?

Question

Possible Duplicate:
PHP: how to get last inserted ID of a table?

This is my query for inserting a new post into the posts table (PHP/mysql). Can I return the post_id for the post just inserted in the same statement? I need the post_id for insertion into another table.

mysql_query("INSERT INTO `posts` (`post_id`, `date`, `title`, `content`) VALUES (NULL,    NOW(), '$title', '$fileName')");

@Michael typo in first comment `mysql_insert_id()` or `SELECT LAST_INSERT_ID()` — Dejan Marjanović, Jul 11 '12 at 23:19

score 0 · Answer 1 · answered Jul 11 '12 at 23:17

0

mysql_insert_id() will give you the last ID

answered Jul 11 '12 at 23:17

christian.thomas

1,122
1
8
19

score 0 · Answer 2 · answered Jul 11 '12 at 23:18

0

This is exactly what the MySQL function last_insert_id() is for. So, essentially the answer is, "no, but kinda". You need to execute an additional query "select last_insert_id()", which will return 1 row, with your ID in it.

answered Jul 11 '12 at 23:18

Chris Trahey

18,202
1
42
55

score 0 · Accepted Answer · answered Jul 12 '12 at 00:23

0

mysql_query("INSERT INTO `posts` (`date`, `title`, `content`) VALUES (NOW(), '$title', '$fileName')");
$last_inserted = mysql_insert_id(); // return last inserted id

answered Jul 12 '12 at 00:23

sel

4,982
1
16
22

Return a value from an INSERT query in mysql?

3 Answers3