如何将数组值插入数据库表的列？

Question

I have an array with three values red, green and yellow. Now i should

insert red into column3 row1
insert green into column3 row2
insert yellow into column3 row3

How can i do that i tried writing the code

foreach ($output as $value)
{
    echo ($value.'<br>');
    $tstring = implode(',' , $output);
    $insert_col= "UPDATE INTO `5` (B) VALUES ('$tstring')";
    $insert_result = mysql_query($insert_col);
    if ($insert_result)
    { 
        echo ("RECORDED!")|
        exit();
    }
}

but it does not work. it is filling extra rows to the existing table with a value R.

Please help!

Answer 1

if I remember correctly, an UPDATE statement should have a WHERE clause.

Like:

 UPDATE table SET column_name='value' WHERE condition;

You can find examples at w3schools.

As for inserting the right value:

foreach($output as $value){
     $tstring = $value;
     $insert_col = "UPDATE `5` SET B='" . $tstring . "' WHERE insert a condition here";
     $insert_result = mysql_query($insert_col);

    if ($insert_result) {
         echo ("RECORDED!") |
    }
}

You don't want to insert all your array in one row, which means that the implode is useless.

And I repeat, you need a WHERE clause here. Without it, you'll update all your rows with the same values.