1000 rows??

sstonge

Any one know why I can't seem to add more that 1000 rows to my table in MySQL??

I'm using a loop in php to add the data, but nothing is added after the 1000th line? and no error shows.

I also tried to add rows using the MySQL Control Cebter to see if was my php that was wrong, but after I add another line then close and open the table again there are only 1000 rows??

HELP!

LordShryku

Are you adding the rows one by one?

ctimmer

How are you determining there are only 1000 rows. Maybe you are only seeing the first 1000 rows.

Sxooter

Do you have an autoincrement field that's set to stop at 1000?

drawmack

do you have an autoincrement field that only allows 3 digits and is starting with 0?

sstonge

I think it was the program I was using to view the rows... it would only show 1000... you know of any good ones that will display everything?

and no I was not using any autoincrement.
and I was adding the recorsd one at a time from an array using a loop unsing the INSERT command

superwormy

phpMyAdmin

LordShryku

OR...this is a php site....you could just write one :p

chads2k2

LOL yeha I agree. Man you kill me!

LordShryku

No no, I frag you 😃

Moonglobe

Originally posted by LordShryku
No no, I frag you 😃

/me whips out q3a and ut2k3 and starts preacticing to kick Shryku's ass

LordShryku

I ain't all that at Quake, but you're gonna hafta practice hard if you wanna get me in UT2K3. And watch out when Halo comes out. I won't post for months cuz I'll be fraggin away

Moonglobe

same here, same here 😃

LordShryku

Well then maybe we'll hafta get online sometime. I'm sure we got some more gamers in here. Might hafta post it in the EL. I know Bunker's gonna want in....