Re: [PHP] multiple deleting and updating (addnew)

DELETE FROM TableName WHERE UserID IN ('User1', 'User2', '', ..) UPDATE TableName SET fieldName='NewValue' WHERE UserID IN ('User1', 'User2', '', ..) Sejati Opreker wrote: Hi all, I meet a problem when I want to deleting a multiple row, I have a table that contain columns UserID, name, company name

[PHP] multiple deleting and updating (addnew)

Hi all, I meet a problem when I want to deleting a multiple row, I have a table that contain columns UserID, name, company name, and bill. UserID is uniq. perhaps, some of UserID, say it five UserID I have to delete, how to delete all raw that contain that UserID ? and if I want to update bill of a