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 Price
Web Developer Temp
Media Lab, H.H. Brown

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

Reply via email to