[RESOLVED] sql increment

[pinkcow]

hi

i want to increment one field with a update.

$query = 'update '.$GLOBALS['tbl']['polling'].' set total'.$answer.'=total'.$answer.'+1 where idNews='.$id;
$db->q($query);
echo $query;

the output is:
update my_polling set total1=total1+1 where idNews=74

the wierd part is that it increments with 2 instead of 1. if i use the output-string and execute it in phpmyadmin it increments with 1. do i have to use quotes or something? i've even tried with "()" in different positions but unsuccessfull.

thanks

[NogDog]

My guess is that the query is being executed twice. You may need to walk through your code and any included files/classes to see if there is more than one place where the query gets executed (starting with the q() method of your database class).

[pinkcow]

you were right nogdog, should of seen it