RE: [PHP] Three queries. One Form.
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: [EMAIL PROTECTED] -Original Message- From: jack jackson [mailto:[EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Three queries. One Form.
Hello jack, Friday, June 10, 2005, 12:05:35 AM, you wrote: jj I am trying to make one form on a single page insert info into three jj tables; query 1 creates an art_id (auto-increment) for the newly jj created row in table art; jj query2 creates a media_id in table media. jj Then I need to get the art_id and media_id created by the first two jj queries to insert into an intersection table as query three. Assuming MySQL - just use 2 insert statements and after each one get the last_insert_id. Once you've got both of those you can perform your third and final insert using both of those values. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I do not fear computers. I fear the lack of them. - Isaac Asimov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Three queries. One Form.
On 6/9/05, Matt Babineau [EMAIL PROTECTED] wrote: 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. Thanks, Matt! Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From: jack jackson [mailto:[EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Three queries. One Form.
Thanks for this Richard! On 6/9/05, Richard Davey [EMAIL PROTECTED] wrote: Hello jack, Friday, June 10, 2005, 12:05:35 AM, you wrote: jj I am trying to make one form on a single page insert info into three jj tables; query 1 creates an art_id (auto-increment) for the newly jj created row in table art; jj query2 creates a media_id in table media. jj Then I need to get the art_id and media_id created by the first two jj queries to insert into an intersection table as query three. Assuming MySQL - just use 2 insert statements and after each one get the last_insert_id. Once you've got both of those you can perform your third and final insert using both of those values. Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I do not fear computers. I fear the lack of them. - Isaac Asimov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php