Kalland Posted January 16, 2010 Share Posted January 16, 2010 Hi! I have a private message system. And the user can select several messages in his inbox and delete the selected messages. Do I have to loop through all the id's and run a update query? Or can I do it easily with one query passing the array of id's in it? I tried this, which did not work: UPDATE pm SET deleted = 1 WHERE pmID IN ( $ids ) Quote Link to comment Share on other sites More sharing options...
Kalland Posted January 16, 2010 Author Share Posted January 16, 2010 Solved it using PHP's implode function.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.