Large Union query failing from PHP, works in SQL Query Analyzer

[markjoe]

Hopefully this is enough to go on.

PHP 5.2.5 connecting to SQL Server 2000.

I have a fairly large union query that runs fine in SQL Query Analyzer in 1 minute 19 seconds.

Run from PHP it fails with the last message being "Changed database context to 'DB NAME'".

If I shorten the date range to a single day, it runs in PHP fine.

This is how I am checking the date range:

where datecol >= 17373 and datecol <= 17375

(date is integer date stamp in DB)

I echoed the full query from the PHP script and pasted it in SQL Query Analyzer.