[Resolved] Mysql 4.0.18 duplicates

trooper

I've just written a php site which runs fine on mysql 4.0.16
but when i run it on the live site which runs mysql 4.0.18 it puts in two records everytime not just one

Has anyone experienced this - is there a problem with mysql 4.0.18

As i said its fine on the development server and the problem only happens on the live server.;

Any help would be great

LordShryku

That sounds odd....
Have you tried running the SQL against the DB without using PHP? That's more commonly a PHP problem instead of a MySQL problem. Is there any differences in the PHP configurations between the servers?

BTW...congrats on the book. I'm probing it right now to find things to harrass you guys about 😃

trooper

Well guess what

In a last ditch effort i aske the client to upgrade to IE 6 (they were on IE5) and guess what ...... IT sorted the issue (well the one about duplicates going into the D😎

I knew it wasn't my code (i'm not that bad hee hee)

So if anyone has the problem ask them to upgrade - i know its usually the first thing that developers as but it waas the last thing and it turned out to be the problem. I have NO idea why but hey who knows anything about anything