RE: [PHP-DB] Updating multiple forms
| From: | SOHH Administration | Date: | Wed, 18 Apr 2001 16:46:05 +0000 |
| Subject: | RE: [PHP-DB] Updating multiple forms | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8654@lists.php.net to get a copy of this message | ||
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:shahmatd@sains.com.my]
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: 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