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, 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 users (multiple user) that data of users taking from a file ( so the file contain user UserId and bill), how to make it ?
Thanks,
Aji
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
