Basically you write multiple query statements.  Like so:

$query_updatetable1 = "UPDATE table1 SET fieldname WHERE fieldname = x";

$result_updatetable1 = mysql_query($query_updatetable1);

$query_updatetable2 = "UPDATE table2 SET fieldname WHERE fieldname = y";

$result_updatetable2 = mysql_query($query_updatetable2);

$query_updatetable3 = "UPDATE table3 SET fieldname WHERE fieldname = z";

$result_updatetable3 = mysql_query($query_updatetable3);

That will do it, because I update multiple tables on my site.

Steven Samuel
http://www.sohh.com

-----Original Message-----
From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:27 AM
To: Lester June Cabrera; PHP-DB
Subject: Re: [PHP-DB] Updating multiple forms


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]

Reply via email to