Re: Re: Incrementing variables based on database data

Why not let the DB do this for you? You can group by whatever column that is and select count(*), column_your_looking_for. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Vinny Gullotta wrote: > Nevermind, I figured it out. I needed to make the if statements use == > instead of = like this: > > if ($i[4] == "IISRESET") { > $iiscount = $iiscount + 1; > } > > etc. =) > > > ""Vinny Gullotta"" <vgullotta@intermedia.net> wrote in message > news:A0.25.04075.476F1A84@pb1.pair.com... >> below is the output I'm seeing along with my code. There are 11425 >> items in the database, many of each of these possible values for >> $i[4], however you'll see from my Output that the $iiscount variable >> is the only one being incremented and it is getting incremented for >> every row in the table. Can anyone see anything I'm doing >> incorrectly? The data in this column in the table is formatted as >> TEXT. Thanks in advance for any help you can provide. =) >> >> 11425 >> 0 >> 0 >> 0 >> 0 >> 0 >> 0 >> 0 >> >> ____________________________________________ >> $query = "SELECT * FROM table"; >> $result = mysql_query($query) or die(mysql_error()); >> $iiscount = 0; >> $cfcount = 0; >> $nlbcount = 0; >> $srcount = 0; >> $sacount = 0; >> $rebootcount = 0; >> $apccount = 0; >> $othercount = 0; >> >> while($i = mysql_fetch_row($result)) { >> if ($i[4] = "IISRESET") { >> $iiscount = $iiscount + 1; >> } elseif ($i[4] = "CF Restart") { >> $cfcount = $cfcount + 1; >> } elseif ($i[4] = "NLB STOP IISRESET") { >> $nlbcount = $nlbcount +1; >> } elseif ($i[4] = "Service Restart") { >> $srcount = $srcount + 1; >> } elseif ($i[4] = "Restart System Attendant") { >> $sacount = $sacount + 1; >> } elseif ($i[4] = "Reboot") { >> $rebootcount = $rebootcount + 1; >> } elseif ($i[4] = "APC Reboot") { >> $apccount = $apccount + 1; >> } elseif ($i[4] = "Other") { >> $othercount = $othercount + 1; >> } >> } >> echo $iiscount, "<br>"; >> echo $cfcount, "<br>"; >> echo $nlbcount, "<br>"; >> echo $srcount, "<br>"; >> echo $sacount, "<br>"; >> echo $rebootcount, "<br>"; >> echo $apccount, "<br>"; >> echo $othercount, "<br>"; >> ?> >> >> >