Re: Updating a record with math and division
| From: | Miles Thompson | Date: | Fri, 28 Dec 2001 22:43:47 +0000 |
| Subject: | Re: Updating a record with math and division | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15251@lists.php.net to get a copy of this message | ||
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