Query occasionally not working

[Phil Johnstone]

I find that on occasions when I get a php script to perform an update query and it just doesn't work. If I reload the exact same page with the exact same query, but echo it, copy it then run it through a console it always works.

Stranger still, if i keep refreshing the php page, the query will eventually work, but it seems to only work randomly. There is nothing special about the script that would not allow the query to finish properly, it pretty much just updates a record with given information.

It seems to work when I replicate the whole process on my desktop machine, the only difference being the OS and IIS version. Anyone had anything similar to this before?

Production Server:
MySQL 4.1.4
php 5.0.1
IIS 5
Windows 2000 Server (Standard)

My Desktop (Test machine)
MySQL 4.1.4
php 5.0.1
IIS 6
Windows XP Professional & SP2

Cheers,

Phil Johnstone