Updating records in mysql using array

Hello, is there other way instead doing this code? Where fields and value are inside the array.

$query=mysql_query("UPDATE $tbl SET $fields[0] = $value[0], $fields[1] = $value[1], $fields[2] = $value[2] WHERE id = '".d($_GET['i'])."'");

PHP:

Thanks.

 

You could take this approach...


// start building qry
$qry = "update $tbl set ";

// count how many elements in the array;
$total = count($fields);

// loop over total
for ($i=0; $i<$total; $i++){
// append to qry so query looks like: field = 'value',
$qry .= $fields[$i] ." = '".$value[$i]."'," ;
}

// chop off last comma
$qry = substr($qry, 0, -1);
// add where statement
$qry .= "WHERE id = '".d($_GET['i'])."'")";

$result = mysql_query($qry);

This is not tested, there could be a syntax err in there.

 

hm I would execute as many queries as array fields you have, if they are many
just set the query and execute it inside the loop fetching the array