Re: PHP Add +1 mysql updates by 2?
| From: | Richard West | Date: | Sat, 27 Nov 2010 05:13:24 +0000 |
| Subject: | Re: PHP Add +1 mysql updates by 2? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-309699@lists.php.net to get a copy of this message | ||
No
On Nov 26, 2010, at 10:53 PM, Tamara Temple wrote:
>
> On Nov 26, 2010, at 8:36 PM, Richard West wrote:
>
>> Hey guys,
>> I've never run into this before.
>> I have a field in mysql for page views.
>> So I pull out value and do +1 to new value - after UPDATE SET it has incremented by 2?
>>
>> $val = $row['a_downloads'] ;
>>
>> $new_val = $val+1;
>>
>> mysql_query("UPDATE cbn_articles SET a_downloads='$new_val' WHERE a_id =
>> '".$_GET['id']."' ");
>>
>> Any ideas? What am I missing?
>> RD
>
> a_downloads wouldn't happen to be an autoincrement value, would it?
>
>