Re: Updating multiple forms

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 <lester@i-quest.com> To: Shahmat Dahlan <shahmatd@sains.com.my>; PHP-DB <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net