07-04-2008, 12:11 PM
|
#6 (permalink)
|
|
The Frequenter
Join Date: Sep 2007
Location: Denmark
Posts: 352
Thanks: 8
|
Yea thats what it looks like, you can ofcourse generate it in PHP if its names like "n[n]" where [n] is a number like:
PHP Code:
function generate_update_rows($value = NULL)
{
$compiled_stack = Array();
/* Start number: 1 - End number 50 */
$times = 50;
for($n = 1; $n < ($times + 1); ++$n)
{
$compiled_stack[$n] = '`n' . $n . '`' . (!is_null($value) ? ' = \'' . addslashes($value) . '\'' : '') . (($times - 1) != $n ? ', ', '');
}
return(implode(' ', $compiled_stack));
}
And in your query just have like:
PHP Code:
$sql = 'UPDATE `table` SET ' . generate_update_rows('NULL') . ' LIMIT 1;';
__________________
Last edited by Kalle : 07-04-2008 at 04:27 PM.
|
|
|