$ results会返回多个结果，但只有最后一个会在mysql_query上更新。 需要全部更新

Question

I know this should be kind of simple, but I just can't figure it out on my own. So heres the code:

while($row01=mysql_fetch_array($res01))
{
    $results=stripslashes($row01['spec_search'])." ";
    echo $results;
    mysql_query("update products set search='".$results."' WHERE id='".$row['id']."' ");
}

The $results return multiple values. It echoes well, like "tree bag shoes". But at the *mysql_query* only the last result (shoes in this example) gets updated in my table. How can I make it so that everything gets updated?

Many thanks!

Answer 1

You are using $row['id'] in the query, but the loop's current row is accessed by $row01['id'].

The database is not updating once, but multiple times. However as the updates are being applied to the same row, only the last update is visible.

Update you code to the following

while($row01=mysql_fetch_array($res01))
{
    $results=stripslashes($row01['spec_search'])." ";
    $specArr[$row['id']][]=$row01['id'];
    echo $results;
    mysql_query("update products set search='".$results."' WHERE id='".$row01['id']."' ");
}