Dont think it made sense last time (too little coffee, too much work!)
try again IF there is a formula for the value of quantity eg Quantity = Quantity -1 (UPDATE table SET Quantity = Quantity-1 ) IF there is no formual you need to do an update statement for each row EG UPDATE table SET Quantity = "2" WHERE Field = Book1 UPDATE table SET Quantity = "4" WHERE Field = Book2 UPDATE table SET Quantity = "9" WHERE Field = Book3 HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: 18 April 2002 23:30 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Updating Many Records > > > IF there is a formula for the value of quantity eg Quantity = Quantity -1 > (UPDATE table SET Quantity = Quantity-1 ) you need to do an > update statement > for each row > > EG UPDATE table SET Quantity = "9" WHERE Field = Book3 > > HTH > > Peter > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: 18 April 2002 14:21 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Updating Many Records > > > > > > I am not sure if this is possible. > > > > I have a database, and we fetch all the records and then list them. > > > > What we need is the one field in the database to be able to be updated. > > > > Now the field will have different values for each record. Is it > > possible to update the table with lots of different values? > > > > So for example we have: > > > > Field Qantity > > Book 1 5 > > Book2 6 > > Book3 9 > > > > Now when we are shown all these records the quantity is a form > > field and we want to change this but for each record? > > > > Hope the above is enough to go on. > > > > Barry > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
