PHP Page Won't Load Doing MySQL SELECT

[andygrant]

I'm having a problem with a couple of pages that won't load when I perform a certain MySQL SELECT.

 

When trying to open these pages in Internet Explorer it shows page not found and in Firefox a popup prompt is shown asking if I want to open the page in Dreamweaver or save the file.

 

The pages are getting data from 4 linked tables, the details of the tables are below. The search should return 4,677 results and it works fine if the tables are smaller or if there are extra parameters to limit the amount of results. The database has 28 tables and is only 1.7Mb total size so there aren't loads of columns in each table.

 

The data is borken onto pages so not all the data is being shown to the screen so the actual pages that should output is quite small.

 

table1, 4,677 rows, 262.8kb

table2, 7,506 rows, 536.0kb

table3, 2,815 rows, 117.9kb

table4, 4,677 rows, 110.1kb

 

Could something be timing out, is there a limit to the size of the data that can be returned? Although I wouldn't expect a large size of data is really being returned.

 

Any help will be appreciated.

 

Many Thanks