Off the top of my head, and it's 3am local so take this with a grain of
salt, but I think that
this will work...
Update Table1, Table2 SET Table1.column1 = 'blah', Table2.column1='foo'
WHERE
Table1.ID = x AND Table2.ID = y
'Luck
-Szii
----- Original Message -----
From: Lester June Cabrera <[EMAIL PROTECTED]>
To: Shahmat Dahlan <[EMAIL PROTECTED]>; PHP-DB <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 2:29 AM
Subject: Re: [PHP-DB] Updating multiple forms
>
> Multiple tables with different fields? Hmm... I don't know of any shortcut
> in doing it.
>
>
> At 05:27 PM 4/18/01 +0800, Shahmat Dahlan wrote:
> >Yes, this is only applicable if I only have one table. What if I need to
> >update multiple tables?
> >
> >
> >Lester June Cabrera wrote:
> >
> > > I guess you need to use the UPDATE command
> > >
> > > UPDATE tablename
> > > SET column1 = 'some value'
> > > WHEREcolumn2 = 'another value';
> > >
> > > Did I get what you mean?
> > >
> > > Lester
> > >
> > > At 05:02 PM 4/18/01 +0800, you wrote:
> > > >Apologies...
> > > >Lemme rephrase my question,
> > > >How do I update data into multiple tables in MySQL?
> > > >
> > > >Shahmat
> > > >
> > > >Lester June Cabrera wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > What do you mean by updating data into multiple forms? Do you mean
> > > > > displaying data in multiple HTML forms?
> > > > >
> > > > > Lester
> > > > >
> > > > > At 04:53 PM 4/18/01 +0800, Shahmat Dahlan wrote:
> > > > > >How do I update data into multiple forms?
> > > > > >
> > > > > >Thanks in advance..
> > > > > >Shahmat
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
