Posted by jack jackson on 10/20/87 11:18

Thanks for this Richard!


On 6/9/05, Richard Davey <rich@launchcode.co.uk> 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
>
>

• Next in forum: Re: [PHP] Making a page loop with header('Location: ...
• Prev in forum: Making a page loop with header('Location: ...
• Thread view: Re: [PHP] Three queries. One Form.

[Reply to this message]