Hi
Please can anyone helpme to upload 2000 records from excel file into Mysql database. while uploading it should check for the duplication . Ihave used the inarray function to check the duplication. It works for 300 records. But when i insert 1000 records, it shows me the error to increase the memory limit to 16MB. when i increase the memory size it gives me the error as Timeout.


by,
shaalini.s

you can use this function:

set_time_limit ( Seconds );

1. if you give Seconds as 60 - the page will execute upto 60 sec.

set_time_limit ( 60 );


2. OR - you give Seconds as 0 (zero) - the page take the maximum excute

time to that page.

set_time_limit(0);