[PHP] update entries in a table

2002-04-12 Thread Norman Zhang 

Hi,

How do I update entries in MySQL? Say for example, I checked some fields to
a table, and decided to make update to a particular field. How do I do that
in PHP?

Regards,
Norman



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update entries in a table

2002-04-12 Thread Richard Baskett 

Take a look at:

http://www.mysql.com/doc/U/P/UPDATE.html

It'll have everything you'll ever want to know about UPDATE :)

Rick

There is no such thing as a sudden heart-attack. It takes years of
preparation. - Unknown

 From: Norman Zhang [EMAIL PROTECTED]
 Date: Fri, 12 Apr 2002 14:23:28 -0700
 To: [EMAIL PROTECTED]
 Subject: [PHP] update entries in a table
 
 Hi,
 
 How do I update entries in MySQL? Say for example, I checked some fields to
 a table, and decided to make update to a particular field. How do I do that
 in PHP?
 
 Regards,
 Norman
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update entries in a table

2002-04-12 Thread Erik Price 


On Friday, April 12, 2002, at 05:23  PM, Norman Zhang wrote:

 How do I update entries in MySQL? Say for example, I checked some 
 fields to
 a table, and decided to make update to a particular field. How do I do 
 that
 in PHP?

// $db = database connection handler
$update_sql = UPDATE tablename SET tablename.columname = '$value';

if (!mysql_query($update_sql, $db)) {
die(Could not process update SQL query);
}

Erik





Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update entries in a table

2002-04-12 Thread Erik Price 


On Friday, April 12, 2002, at 05:35  PM, Erik Price wrote:

 How do I update entries in MySQL? Say for example, I checked some 
 fields to
 a table, and decided to make update to a particular field. How do I do 
 that
 in PHP?

 // $db = database connection handler
 $update_sql = UPDATE tablename SET tablename.columname = '$value';

 if (!mysql_query($update_sql, $db)) {
   die(Could not process update SQL query);
 }


Of course, as an afterthought, you might want to qualify that with a 
WHERE clause, lest you update every row of your table...


Erik





Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update entries in a table

2002-04-12 Thread Norman Zhang 

Thank you so much.

Norman




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php