addition in database update

[danielle]

i'm assuming this can be done but i'm unable to find any "how to" info via this site,google & mysql site...

all i want to do is add to a field in an update -

out of context form code:

if ($a_gift[numselected]<$a_gift[numrequested])
          {<input type=radio name=giftid value=$a_gift[giftid]>

hypothetical update query:

$update_gift="update giftregistry set numselected= numselected + 1  where giftid='$giftid'";

or numselected +=1 ??

i know i can do a select of the correct row, get value of numselected, add 1 then do the update but i'm trying to be a good girl and do it in one step...

does that make sense at all? i need more coffee.... :rolleyes:

[DonChris]

"set numselected= numselected + 1"
will work...

[helz]

the code you put is the same as a working version that i use on my site:

$sql = "UPDATE table SET field=field+1 WHERE id='$id' ";

[danielle]

groovy thanks! i was nervous to try - didn't want to screw up the db. 🙂