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>

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 >

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 t

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] -Or