Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread Lester June Cabrera


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]




Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread Shahmat Dahlan

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]




Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread Shahmat Dahlan

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]




Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread fabrizio . ermini

On 18 Apr 2001, at 17:27, Shahmat Dahlan wrote:

 Yes, this is only applicable if I only have one table. What if I need to
 update multiple tables?
 
Shamat, it seems we need some more info to understand your 
needs. What precisely are you trying to do?


/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Fabrizio Ermini   Alternate E-mail:
C.so Umberto, 7   [EMAIL PROTECTED]
loc. Meleto Valdarno  Mail on GSM: (keep it short!)
52020 Cavriglia (AR)  [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]




Re: [PHP-DB] Updating multiple forms

2001-04-18 Thread Szii

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]




RE: [PHP-DB] Updating multiple forms

2001-04-18 Thread SOHH Administration

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]