RE: [PHP] multiple deleting and updating raw mysql via php
| From: | Jay Blanchard | Date: | Wed, 05 Jan 2005 13:25:51 +0000 |
| Subject: | RE: [PHP] multiple deleting and updating raw mysql via php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-205666@lists.php.net to get a copy of this message | ||
[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.