updating data php array

[Dynamo]

Hi,

How can I update data to mysql if I had array with values?

---

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

$id[] = $row['id'];
$name[] = $row['name'];

$result = mysql_query("UPDATE example SET name='$name' WHERE id='$id'")
or die(mysql_error());

}

---

Dynamo

[tsinka]

Hi,

you need to execute the update queries separately in each iteration of the loop.
But depending on the select query there might be a solution to update the example table with just one query.

How does the select query look like ?

Thomas