add numbers

[adzie]

Hello guys sounds like a simple question but...

 

i want to update a number in the database

 

so something like below where hours is the existing data.  At the moment all I get is the 200 not the original plus 200

 

UPDATE user SET hours = 'hours' + '200' WHERE user_id = 1

[Philip]

UPDATE `user` SET `hours`=`hours`+200 WHERE `user_id` = 1

 

You don't need the quotes around the col name like that

[adzie]

Thanks that brilliant, what if I want to add say time?  say 200:14:12 ?

[Philip]

Use the datetime functions:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

 

[adzie]

thanks kingphillip

 

The trouble is if the hours are over 838:59:59 i couldnt get a time function to work

 

hours = ADDTIME(`hours`,'$time')

[Philip]

I haven't tried it, but I've heard that using TIMESTAMPADD() works sometimes. I'll see if I can pull up that article

 

[adzie]

cheers

 

I found an example and tried that but couldnt get a result

[adzie]

i've added the time as a varchar field but cant add 10:10:10

[fenway]

What's wrong with a good ol' INT?