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
