need help with UPDATE from an array

[DougieC]

I am getting the values from a check box and go through a loop to get the values ' 1 ',' 2 ',' 3 '.
what I am wanting to do is replace the existing values with the new ones
i bring in with the array. so for example I had

AgencyID__ServiceID
1 ______1
1 _________ 2
I would Like it to change to

AgencyID__ServiceID
1 ______1
1 _____ 2
1 _________3
here is my sql query

<?php

UPDATE AgencyServices ags 

INNER JOIN AgencyServices ON (ag.AgencyID = ags.AgencyID) 
INNER JOIN Services s ON (ags.ServiceID = s.ServiceID) 
INNER JOIN UserLogin ul ON (ag.AgencyID = ul.AgencyID) 

SET ags.ServiceID IN (' 1 ',' 2 ',' 3 ' ) // i think thats my problem

WHERE ul.UserName ='blah'
AND ul.Password ='blah'

?>

Any help would be great!!! Thanks

[BlueMeteor]

My suggestion

For example, you save new values by $result[] ,as $result[]'s count maybe [' 1 ',' 2 ',' 3 ' ] or [' 1 ',' 2 ',' 3 ' .....'9'].....

so u had better delete old records first and insert new records

First step:
delete AgencyServices where WHERE ul.UserName ='blah'
AND ul.Password ='blah'

second:
foreach($result as $value)
{
insert into AgencyServices value(UserName ,Password ,$value)
}

[DougieC]

Thanks I'll try that😃