[RESOLVED] Split not working...

[kiwis]

$name = "1323,544,4545,45,4542";

$split = explode(',',$name); 

mysql_connect (localhost, **, **);
mysql_select_db (**);



foreach ($split as $value) {

$result = mysql_query ("UPDATE NEWS SET BLOCK = '1' WHERE NewsID = '$value'");
//$name = "Value: $value<br />\n";
}

This only updats my first value not the rest why??

[Weedpacket]

I don't see an obvious reason why, but the loop is unnecessary anyway.

UPDATE NEWS SET BLOCK = '1' WHERE NewsID IN (1323,544,4545,45,4542)

[kiwis]

I've played with this in PHPMyAdmin I have this SQL line

UPDATE  `RLNZ_NEWS`  SET BLOCK =  1 WHERE NewsID = ('7491, 7490') 

I've also had it 7490, 7491 either way only the first one works. What is wrong?

Have also done this

UPDATE  `RLNZ_NEWS`  SET BLOCK =  1 WHERE NewsID = ('7491', '7490') 

[kiwis]

Arr IN not =