RE: [PHP-DB] Updating multiple forms

[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]

[PHP-DB] Moving The Pointer In An Array

[SOHH Administration]

Lets say you have and array called $contentarray which contains the
following values in this order: 10,19,9,8,234,3

These values represent the articleID.  So if a person was on my site reading
an article the url would look like so:
http://website.com/read.php?articleID=8

So, the article the user is reading is 8.  How do I tell the POINTER in the
array that I am at $contentarray[3]?  If I need to give more details, holla
back.

Steven



-- 
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]