|
|
Posted by "Matt Babineau" on 10/08/64 11:18
Well after the first query you could do this:
$art_id = mysql_insert_id();
There is your new unique art_id you just created.
Do this for the next table, the do the insert on your 3rd table.
Matt Babineau
Criticalcode
w: http://www.criticalcode.com
p: 858.733.0160
e: matt@criticalcode.com
-----Original Message-----
From: jack jackson [mailto:jackson.linux@gmail.com]
Sent: Thursday, June 09, 2005 4:06 PM
To: php-general@lists.php.net
Subject: [PHP] Three queries. One Form.
Hi,
I am trying to make one form on a single page insert info into three tables;
query 1 creates an art_id (auto-increment) for the newly created row in
table art;
query2 creates a media_id in table media.
Then I need to get the art_id and media_id created by the first two queries
to insert into an intersection table as query three.
Must I run an intermediate query to get the ids, and assign it to vars? What
would it even look like?
Thanks in advance,
--
PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
Navigation:
[Reply to this message]
|