Unable to save result set

I'm running windows ME with mysql, php 4 and apache. I have started getting the following error: Unable to save result set

when trying to do a simple query:

$monthlyresult = mysql_query("select * from month");

Any ideas on how to correct this problem or what is causing this problem.

Thanks

Ray

Make sure your disk isn't full. I got this error on a new machine running mySQL and it was because a volume wasn't configured with enough space.

Try doing the query from the mySQL command line interface, to eliminate PHP and the web server as potential problems.

Tac

Try selecting a column instead of all:

$monthlyresult = mysql_query("select ColumnName from month");