TalkPHP - View Single Post - Updating multiple columns in a single record

Kalle · 07-04-2008, 11:36 AM

Hey

As far as I know theres no command to "updte all the rows" like you can select all rows in a statement.

So you need to do something like:

PHP Code:


			
$sql = 'UPDATE `table` SET `n1`, `n2`, ..., `n50` = NULL WHERE `id` = \'' . $something_unique . '\' LIMIT 1;';

07-04-2008, 11:36 AM	#4 (permalink)
Kalle The Frequenter Join Date: Sep 2007 Location: Denmark Posts: 352 Thanks: 8	Hey As far as I know theres no command to "updte all the rows" like you can select all rows in a statement. So you need to do something like: PHP Code: $sql = 'UPDATE `table` SET `n1`, `n2`, ..., `n50` = NULL WHERE `id` = \'' . $something_unique . '\' LIMIT 1;'; __________________