Yes I got that much...

So it would be

UPDATE tblname SET value1 + $value1?
"David Piasecki" <[EMAIL PROTECTED]> wrote in message
000201c18ffd$a8187ec0$a6ccb0d8@pc5">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:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 4:06 PM
> To: [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
> >
> > 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to