Re: update entries in a table
| From: | Erik Price | Date: | Fri, 12 Apr 2002 21:41:03 +0000 |
| Subject: | Re: update entries in a table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-92811@lists.php.net to get a copy of this message | ||
On Friday, April 12, 2002, at 05:35 PM, Erik Price wrote:
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 pricee@hhbrown.comHow 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"); }