Maximum execution time exceeded!

hi all, when i am trying to calculate the number of rows with a '0' in a particular column using the following code, it is giving the 'Maximum execution time exceeded' message, eventhough after i gave set_time_limit(60), it didn't worked, infact now it is even worse the browser is getting siezed. $result=mysql_query("select * from mytable"); while ($avgrow=mysql_fetch_array($result)) { $prescene2 = $avgrow["scene2"]; $prescene4 = $avgrow["scene4"]; $prescene5 = $avgrow["scene5"]; $prescene7 = $avgrow["scene7"]; $prescene8 = $avgrow["scene8"]; $prescene9 = $avgrow["scene9"]; $i = 1; while ($prescene2 == 0) { $i=$i+1; } } printf ("Number of zeros=%d",$i); Can any one please help me with this. TIA kalyan __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/