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
GM
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 
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