Table leaves pages hanging!

[newtophp]

I have one main table with several related tables linked to it. When I try to access a php file that connects to this table, the page is just left hanging (the bar fills up, but the page is never shown.

 

Also, when I try to access this table via the Admin panel, the page hangs and never loads.

 

Other pages that display information from the other tables load fine.

 

These pages have always loaded fine in the past. What’s happened?

 

Any advice is appreciated!!!! Thanks.

[shivabharat]

There is a chnace your table might have got corrupt. Are you able to query the table in the mysql prompt?

 

Check this out

 

http://www.phpfreak.com/mysqlmanual/page/m...able_types.html

[newtophp]

The table actually worked for a few minutes today and the pages displayed correctly. I ran a check on the table and it came back OK. Then told it to repair the table (just in case) and that came back OK.

 

A few minutes later, the table stopped working again!

 

Any help, please!!!!!!!!!!!!!!!!!!!!!!!!

[effigy]

no settings have changed? how does the free disk space look?

 

try running your SQL statement directly in the mysql monitor, and prefix it with EXPLAIN. the results could possibly help; however, it is funny that this worked beforehand.