Incrementing a counter in the database

[eluser]CI Simon[/eluser]
[quote author="Sumon" date="1220877852"]i am not clear how is it be an operating system issue.[/quote]

It wasn't anything to do with the operating system. I still do not 100% understand what was happening but it was to do with the join in the original query and trying to use the ID field which was picking up the ID from the wrong table.

Why was it working locally - i need to do further tests but I think it was simply coincidence.

Of course I didn't post enough details for anyone to pick this up :red: but I learnt some stuff along the way.