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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
