limit 1040 entries, why?

i only can insert 1040 entries!
is that a php or a mySQL problem, and it's possible to solve it (how)

cheers

hello

you mean
1) 1040 rows in a table
2) 1040 chars in a field?

if you mean (1) ,,, then , are you tring to insert them all at one time ( if this is the case , it is because of the execution time limt by PHP ) anyway it is not a good idea .

if you mean (2) what type is the field ?
I can't figure out a type which limits only 1040 , CHAR + VARCHAR are 255 , and TINYTEXT is 255 , TEXT is 65535

Could you please give us more info about this ?

good luck .

i have a loop which i insert more then 2000 raws in a table, after every insert i use "set_time_limit(30000); ", the problem is that the script works and works on, without a sign.
I wanna stop the script for a moment to send a request that is still working.

when i brows it localy it works, just over the internet doesn't work

thx

Why you need to set time limit in a loop ?

Set it at the beginning of script and thats it.



I really dont know what you are trying to achieve here.

JD

Hello ,

do as JD said ,

one more thing ,, I really recomend that , instead of increasing the time limit and pump all the 2000 rows stratight to mysql

set a number of records for every loop , use echo to write a java script to refresh the page - and to tell you that the script is still working - with ( last id ) and start over ,
make sure that your code checks for the number of records .

this way is better , although I think you should use perl as shell script to do this

good luck .