MSSQL PHP odd behaviour

[normm]

Hi all I would apreciate some generic help with the following problem as it's probably far too complex to document and solve on a forum but I need some more ideas on how to diagnose this problem.

situation:
PHP running on a Hiawatha server using an mssql 2000 database.

all of my queries run through a php object that runs queries and then builds the data into arrays that are later processed into tables to be displayed on a web page.

all of my queries run correctly apart from one that causes a HTTP 500 error to be displayed in a web browser. the error occurs at the point of execution of the query, I have echoed the query, copied the query string and pasted it directly into sql server management studio and the expected result is returned.

does anyone have any ideas what could cause a query to not run within the php environment when it can be demonstrated that the query is perfectly valid by running it in management studio?

thanks in advance for any help anyone can offer.

Normm

 

[jpadie]

does the php process log any errors whilst processing this query?
it sounds like something in the script is killing the php binary whilst being executed. i assume you compiled php from source, so is is possible that any of the memory handling modules are being corrupted? if you run the script from the command line, do you get the same behaviour? if you run it on an apache server on a supported platform, do you get the same behaviour?