Posted by NC on 09/14/06 23:21

StevePBurgess@gmail.com wrote:
>
> This script snippet that does all the work is shown - the database
> connection is established and after doing its work the script returns
> the user to the referring page.
....
> On my own server this works perfectly - but when I upload it to my
> client's shared server it sometimes works and sometimes doesn't.
> It is intermittent.

Check register_globals setting on the two servers. Maybe something
writes over your GET/POST variables or vice versa...

Also, how do you handle MySQL errors? The behavior you are observing
is consistent with queries not being executed (which could happen when
your MySQL server is overloaded). The script tries to connect to the
MySQL server, gets an error, fails to execute the queries due to no
connection and redirects...

> Could PHP be returning a cached result of the script?

No, but it is possible that the hosting company does. It is unlikely
though, because the problem is intermittent...

Cheers,
NC

[Back to original message]