Script stops running during while()

rennie

I have a php script which simply stops midway through a while loop that processes records returned by a MySQL query. The HTML page continues trying to load the page but the php has stopped running. The script is running in my development environment which consists of php 4.3.4, Apache 1.3.28 and MySQL 4.0.17, installed on Windows XP with Service Pack 2.

I suspect that there may be a problem with my installation configuration for a number of reasons:
- I have a new PC and had to re-install php, Apache and MySQL
- The script executed perfectly on my old PC (which I no longer have) using the same versions of php etc.
- The script executes perfectly in my production environment (which is running on a Linux server using Apache and MySQL)

I cannot find anything in the Apache error log and there is nothing in the MySQL *.err file. I have tried increasing the value of memory_limit in my php.ini file but the script keeps failing around the same record (I have inserted some tracing into the function to report where the script gets to).

Someone please help.......

thorpe

what is inside the loop? i have heard of antivirus programs causing these kinds of problems with asp scripts, not sure if these problems occure with php, but it might be something to look at.

rennie

The while loop cycles through records returned by a query and inside the loop is an if statement which tests if the record exists in another table and performs an action based on the outcome.

Your suggestion on anti-virus software has got me thinking. Unfortunately, the PC I am using is a work laptop which has been secured down to the max. I previously had local administrator rights but these have been recently removed.

Does anyone think its possible that this would affect the execution of my scripts?