Trouble shooting help?

[autumnk]

I am new to php and know only the basics. I made a form using PHP/MSQL for my new job. I tested the code several times before telling my boss it was done.

He says that when he tries to pull 1000 records from the database he does not get all of the records back but when I pull 1000 records I get 1000 all of them back.

Does anyone know what could be causing this? I am working from home so I am using my computer and he is in the office using his computer. that is the only difference I can see. I am going into the office on Friday to meet with him and would like to have a solution or to ready.

[richei]

It all really depends on the system and the configuration. The script is more than likely timing out because the max execution time is set to low. You could also set up pagination so that its not trying to display all 1000+ results at once. Could also be his connection to the server (unless it an intranet). There’s a lot of possibilities when it comes to that kind of thing. Just look for the obvious things first and then for the least likely.

[ErnieAlex]

I agree 100% with Richei, but, also, which browsers are you and your boss using? That might make a difference. Also, displaying 1000 records is way too much. Who would want to scroll down that far? Condense the display with sub categories or whatever to limit the display to 100 or less… Can’t imagine any boss wanting to scroll down 1000 items…