Mysql query insert multiple table same id

Question

I have two table in my mysql database and when I add a new post (by PHP) a new row is created in it:

-Post(ID,title,body)

-pictures(id,id_post,path_picture)

How could I achieve to pass the post ID to the relative pictures id_post ?

Wukerplank · Accepted Answer · 2011-03-08 14:05:45Z

1

After you insert the post you can call last_insert_id to get the ID the post got. See http://php.net/manual/en/function.mysql-insert-id.php

answered Mar 8, 2011 at 14:05

Wukerplank

4,1742 gold badges32 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

symcbean · Accepted Answer · 2011-03-08 14:06:04Z

0

You can't insert into two tables using DML anyway.

To readback the insert_id assigned, perform the insert then call mysql_insert_id()

If you don't want to poll the insert_id from your PHP code, then you'll need to create a stored procedure.

answered Mar 8, 2011 at 14:06

symcbean

48.4k6 gold badges63 silver badges99 bronze badges

Daniel Luca CleanUnicorn · Accepted Answer · 2011-03-08 14:08:04Z

0

Depending on what database library you use you can find out the id of the inserted row.

For example with the mysql library that PHP provides you run mysql_insert_id() right after the query to insert the post is run.

$inserted = mysql_query( $insert_sql );
if ( $inserted )
{
     $Post_inserted_id = mysql_insert_id();
}

answered Mar 8, 2011 at 14:08

1,0971 gold badge12 silver badges31 bronze badges