开发者

Value 10 gets reset to 1

开发者 https://www.devze.com 2022-12-28 09:29 出处:网络
I have this problem, I store a number in a database field. After a while I check if a value exist and if it does I take the number and add 1 this works fine up until 10, when I add a number to 10 it g

I have this problem, I store a number in a database field. After a while I check if a value exist and if it does I take the number and add 1 this works fine up until 10, when I add a number to 10 it gets reset to 2 as if the zero is not counted开发者_如何学C for.

$row = pg_fetch_array($result,0);
$count = (int)$row[1]['count'];

$count++;

Table

  Column  |           Type           |                           Modifiers                           
----------+--------------------------+----------------------------------------------------
 count    | character varying(255)   | 

I also tried to change it to integer the column and also no luck.


You're indexing the row twice. Use either $row[1] or $row['count'], not both. When you use both, the second index operation will index the string, giving you the first character. This will cause problems when you hit double digits.


you need either row[1] or row['count'], but not them both

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号