SQL UPDATE with array imploded

[torsuntsu]

Hi, i´m using this code to update a database, but i get an error,

and i can´t figure it out where the problem is. Here´s the code:

 

function alter_page($page_data, $page_id){

 

array_walk($page_data,'array_sanitize');

 

$fields= '`'.implode('`, `',array_keys($page_data)).'`';

 

$data= '\''.implode('\', \'',$page_data).'\'';

 

mysql_query("UPDATE `paginas` SET ($fields)=($data) WHERE `id`= $page_id")or die(mysql_error());

 

 }

 

Need help. 

 

Thanks,

TorSunTsu

[Barand]

The UPDATE syntax is

 

UPDATE table SET col1 = val1, col2 = val2, ....

[Psycho]

 

function alter_page($page_data, $page_id)
{
    array_walk($page_data, 'array_sanitize');
    $setParamsAry = array();
    foreach($page_data as $field => $value)
    {
        $setParamsAry[] = "`{$field}` = '{$value}'";
    }
    $setParamsStr = implode(', ', $setParamsAry);
    $query = "UPDATE `paginas` SET {$setParamsStr} WHERE `id`= $page_id";
    mysql_query($query)or die(mysql_error());
}

[torsuntsu]

Thanks Psycho. Problem solved.

You Rock!!!!

 

Torsuntsu.

[Psycho]

LOL, you selected your response as the best answer?