5 replies to this topic

[Edmachine]

Hello (again ), this time I am confused really...

I have to insert players for my online football fantasy league one by one, so I make this query

INSERT INTO players (Name,Age,Nat,St,Tk,Ps,Sh,Ag,KAb,TAb,PAb,SAb,Gam,Sav,Ktk,Kps,Sht,Gls,Ass,DP,Inj,
us) VALUES (Dida,34,bra,16,2,3,2,15,300,300,300,300,0,0,0,0,0,0,0,0,0,0) (but I have it in quotes around them), do it with PHPMyAdmin, but it gives out this error:

#1062 - Duplicate entry '0' for key 1

Since the players are new, everything by default is 0 (except skills, ability points, and everything that is not 0). What does it really mean, and how to solve it?

Also, is there an easier way to add more players at one time (without entering their skills one by one)?

Thanks in advance .

[rc69]

The problem doesn't have to do with an ID field. He doesn't have an ID field. Its that he has some field set to be a unique key of some kind (unique and index are the only kinds that i believe care).

See if any of your fields are set to be a "key" and remove the key. If you got phpMyAdmin i believe all you have to do is click a little red x (the key information can be found in the left hand box below the table structure).

[Edmachine]

Actually I have an ID field, but I somehow forgot to set it to auto_increment . Silly me!

Thanks, for pointing that out . But is there an easier way, to add more users in one time?

Can I do this:

INSERT INTO players (allmycolumns,allmycolumns,almycolumns) VALUES (allplayerinfo,allplayerinfo,allplayerinfo)

?

[.CJ]

Use a while loop.

[Edmachine]

Umm... how? I am inserting them trough PHPMyAdmin...

Oh, and yeah, I found out that I can't do multiple users in one query .