Script execution halts when extracting data from mysql table

[jonno946]

Hi there,

I have made a content management system for my site where as all of the pages are stored in a mysql database and called like ?page=about_us etc...

All is working fine, appart from if it is a relatively big page, it does not load it, and the execution of the page cuts out, as if exit; has just been called.

Any idea why this could be?

Any way i can prevent this from happening?

Thanks

Jonno

[cl_stef]

I don't know where your website is but some web hosting services configure their engine to allocate a given amount of memory to each script. If your php/sql queries bypass this quota, the script execution stops and it gives you an incomplete page as result.
This is a way to prevent webmasters from monopolizing server ressources with huge, unjustified requests.

[olaf]

try this at the begin of your script:

set_time_limit(1000);