[RESOLVED] Increment

[obrienkev]

Hi all,

I want a field in a database table to increment by 1. Instead it increments by 2.

Why is this?

$query = "UPDATE statistics SET count = count +1 WHERE country_ID = '$country'";

thanks,

Kevin.

[LoganK]

Use a select, incremente by 1 in PHP, then do the update.

[Weedpacket]

Well, the UPDATE query should work, but only if it's part of some other code - which, chances are, is doing an increment somewhere else as well.