hi all, i've made an application , which serves more than 35 cuncurrent users at a time, now wht i m doing on the page where the data is being submitted is :
run a loop which iterates through all the submitted data of $_REQUEST and i make a query and update that to the Access Database, on every rep of that loop. the loop iterates five times, now .............. if 35 users submit at the same time, the loop will run five time each for each of the user i.e 35 x 5. here my application crashes and every person ( user ) is redirected to the login page, and all the data is lost in-between the application run. note : no error is raised by the script or server. any comments, on how can i do resource sharing or connection sharing etc. to avoid that???? regards raheel --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software