php/mysql insert problem

[drivetowin]

Tweet

Hi

I'm having a problem with php/mysql

if I use insert into table values (xxx,xxx) everything works fine but if I use
insert into table set a=x, b=y, c=z

each new record gets inserted into the table 3 times

Anyone had this happen to them before?

and if so what is the solution - I know I can change all of the statements to use the values () syntax but I'd rather understand why the other one doesn't work.

[Retail-Therapy]

Hmm, works fine for me like this

INSERT INTO table SET a = 'x' , b = 'y' , c = 'z';

So I can't see your problem

(absolutely no help whatsoever )

[drivetowin]

Thanks

[drivetowin]

Just for information I found from examining the server logs the problem was occuring due to the browser reloading the page - so I've now moved the insert code to a small php file on its own with a redirect to the confirmation page and that's working fine.