Updating multiple rows with an array using PHP with mySQLi

[Craig Rushforth]

Please help with updating multiple rows with an array using PHP with mySQLi

I have managed to do this OK with an INSERT query, but am struggling with the syntax for an UPDATE query.

I would write single row UPDATE query like this...

<?php
if (array_key_exists('submit', $_POST)) {
include('../includes/conn_mysqli.inc.php');
include('../includes/corefuncs.php');
// remove backslashes
nukeMagicQuotes();
// initialize flag
$OK = false;
// create database connection
$conn = dbConnect('admin');
// create SQL
$sql = 'UPDATE tblsize SET Display = ? WHERE SizeID = ?';

// initialize prepared statement
$stmt = $conn->stmt_init();
if ($stmt->prepare($sql)) {
// bind parameters and execute statment

$var1 = $_POST['display'];
$var2 = $_POST['ID'];

$stmt->bind_param('ii', $var1, $var2, $var3);/*s = string; i=integer; d=double; b=binary*/
$OK = $stmt->execute();
}
// redirect if successful or display error
if ($OK) {
header('Location: /xyz.php');
exit;
}
else {
echo $stmt->error;
}
}
?>

Can someone please help me get my head around the syntax for updating several rows at once using an array ?