RE: [PHP-DB] Updating a record with math and division

No... UPDATE table SET value1 = value1 + increment Or... UPDATE table SET value1 = value1 * multiplier ...and so forth... -----Original Message----- From: Todd Williamsen [mailto:todd@williamsen.net] Sent: Friday, December 28, 2001 5:06 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Updating a record with math and division Yes I got that much... So it would be UPDATE tblname SET value1 + $value1? "David Piasecki" <mail-mysql@netvolution.com> wrote in message news:000201c18ffd$a8187ec0$a6ccb0d8@pc5... > You missed the first place you should have looked, the manual page on > the 'UPDATE' syntax: > http://www.mysql.com/doc/U/P/UPDATE.html > > > > -----Original Message----- > From: Todd Williamsen [mailto:todd@williamsen.net] > Sent: Friday, December 28, 2001 4:06 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Updating a record with math and division > > That isn't the answer I was looking for... > > Since you are so <sarcasm>nice</sarcasm> could you be so kind in point > me > where these golden docs are? I looked all over php.net and mysql.com, > nada.... not only that the three books I have as well. I am a newbie at > this, and do need a bit of hand holding thanks... > > > "Miles Thompson" <milesthompson@ns.sympatico.ca> wrote in message > news:php.db-15251@news.php.net... > > > > Read the docs for the database in question. They will tell you what is > and > is not allowed. > > Miles Thompson > > > > On Friday 28 December 2001 06:26 pm, Todd Williamsen wrote: > > > Ok.... > > > > > > So to update a record lets say... > > > > > > I have a current value of 150 and the new value will be 250 now how > would I > > > total them to equal 400? > > > > > > I was thinking > > > > > > $sql = "UPDATE $table value1 = value1 + ? > > > > > > is that correct? how do you update it with simple math? > > > > > > What about division... > > > > > > take the current value in the database + the new value divided by > another > > > number, lets say another field > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net