RE: [PHP] multiple deleting and updating raw mysql via php

From: 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.

« previous php.general (#205666) next »