Re: Incrementing variables based on database data

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>"; ?>

-- Vinny Gullotta Intermedia System Administrator E vgullotta@intermedia.net T (650) 641-4034 F (650) 424-9936 According to Einstein's Theory of Relativity, Chuck Norris can actually roundhouse kick you in the face yesterday!