Adding this back to gether

[NZ_Kiwis]

I have a string in my DB like this 2,44,596,144,1,232

If a user selects say 44 (memberid) i want it removed, this best way i can think of doing this is exploding it then str_replace that value with nothing.

Problem i have is adding the rest back together so i can update the db again. This is what i have but it's wrong...

can someone please help

$respected = explode(',', $stringihave);
foreach($respected as $key=>$value)  {
if ($value == $memberid) {
$update = str_replace ($value, "", $update); 
} 

$update2 = "$update +  $value";
echo $update2;
}

[Earnan]

I hate to say it, but I have to agree with kburger in this thread: <a href="http://phpbuilder.com/board/showthread.php?t=10324618">http://phpbuilder.com/board/showthread.php?t=10324618</a>.

Why does your data look like this?
Your best step would be to normalize your data structure first. Once the data structure is normalized, it is simple to adjust your query to pull only the data you need or to modify the database (in this case, if you want to delete 44, just write a DELETE query WHERE = 44. If you want the 44 removed from your array you are going to use in code, then you write your SELECT query WHERE <> 44).

In the long run, you will save yourself a lot of time and headaches by setting up your data properly now, even if you have to re-write a bunch of query code in PHP.

[geek_girl_2020]

Thanks for the fault spotting Earnan!!

NZ_Kiwis - you should definitely take Earman's advice, Normalisation is the way to go - even if you can come up with stuff to pull out the first string from your field.