How to handle a secondary INSERT related to a primary INSERT

Question

I have 2 tables: user and photos (in a mysql db).

Here you can see the relation between the 2 tables

    User                          Photos
-----------------   -------------------------------
|  id  |  user  |   |   id_user   |   photo_url   |
-----------------   -------------------------------
   ||                      /\   
   ||______________________||
   |________________________|

When I save a new user into the table "user", if the insert is done successfully, I have to take the value of the "id" field of the user just saved, and save it inside the "id_user" field of the table "photos", in order to make a relation between a user and its photos.

Making the first insert (table "user"), then getting, with a SELECT, the "id" of the last record and then again saving the user's photos it's not the right way to do it. How should i do it?

it can help , http://stackoverflow.com/questions/17112852/get-the-new-record-primary-key-id-from-mysql-insert-query — Jimmy, Jul 29 '14 at 20:10

score 0 · Accepted Answer · answered Jul 29 '14 at 20:11

0

To get the auto-incremented ID for the previous insert, you'll want to use mysql_insert_id().

answered Jul 29 '14 at 20:11

Chris Barcroft

562
5
12

score 0 · Answer 2 · answered Jul 29 '14 at 20:14

0

use this toobtain user id: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id

30chars

answered Jul 29 '14 at 20:14

dimzon

414
4
13

How to handle a secondary INSERT related to a primary INSERT

2 Answers2