[snip] 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 ? [/snip]
Are you looking for a query to do this? If I understand you correctly DELETE FROM `table` WHERE `UserID` = 'five'; UPDATE `table` SET `bill` = [data] WHERE `UserID` = 'five'; These are database questions and are best asked on a database list. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php