it will still work even when there are more commas in studentfk. that will depend on your app. if you just want to update all the records where studentno is in it, then you do not need to loop. just execute the update query and it will replace all values that satisfy the where condition.

0

khuz01Author Commented: 2008-02-09

i've tried that but it only works when i give ONE studentfk, when i comma separate more than one, nothing updates or inserts into their table, this is the query: