Duplicate db entries

why might this happen

[Nick_W]

Hi all,

I have a very simple insert statement from php to a mysql db. It is inserting 2 entries every time is is run though?

There is nothing wrong with the code at all so I can't fathom what's causing this, anyone think of anything it might be? If I insert directly from the mysql server it works fine?

Nick

[The Contractor]

Nick
<<There is nothing wrong with the code at all so I can't fathom what's causing this>>

If it works entering directly it would have to be the code. I don't know PHP so I'm no help :)

[Knowles]

By any chance do you have it in a loop? Just a guess and I am guessin you dont since it only does it twice. Other than that its gotta be something to do with the way its pharsing. Possibly is it a var thats beening called twice?

[Nick_W]

GODDAMMMIT!

Would you believe it appears to be a Moxilla thing? I just tested it in lynx and it has no trouble at all!

Seems like Moz is loading the page twice, any thoughts on that guys?

Nick

[Knowles]

I just saw your other post saying the same. I am at a lose now. Maybe kick mozilla and see if that helps?

[DrDoc]

What would make MZ load the page twice though?

Any code samples?

[Lisa]

Uh, you might want to insert a unique key, Have that field unique, Then only one entry can be inserted.

Insert into temp.test values (‘test’, ‘Go for it’, ‘aidxjluw18sl’)

If field three is unique then this statement only works once. Maybe try a primary key, or a multi-primary key. That is how I would get around it.

[Nick_W]

Nope, I'm afraid it was my own abject stupidity.
Well, not really, I think it was an pretty odd mistake to make...

I had this in the html (last place you'd look right?)

<link rel="stylesheet" href="" />

So it was calling itself everytime it loaded!

Doh!

Nick

[Knowles]

LOL Nick I just read this. Dont you hate when it so simple?

[Nick_W]

Especialy when you spend neigh on 3hrs swearing at it, threatning, posting on all the boards for help etc....

Sheesh!