[SOLVED] updating multiple columns with mysqli prepared statements

[ricmetal]

so how do i do it?

 

all i find is how to update one column

 

ive tried SET (col1,col2) VALUES ($var1, $var2) WHERE...

and SET col1 = ?, col2 = ? WHERE

 

but these havent worked

 

appretiate help

[soak]

This shows you what you need to do: http://uk3.php.net/manual/en/mysqli-stmt.bind-param.php

 

If you're asking for help with the update syntax it's:

 

UPDATE `table` SET `field` = 'value', `field2` = 'value2'  WHERE `field3` = 'value3'

[Mchl]

Too little code to help.

[ricmetal]

sorry, i got it working

it was a missing 's'

i just asked cause i didnt find this exaxmple online, and was guessing

 

$stmt = $mysqli->prepare("UPDATE table SET col1 = ?, col2 = ?, col3 = ? WHERE id = ? ")
$stmt->bind_param('sssi', $var1, $var2, $var3, $id);