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@xxxxxxxxxxxxxx> wrote in message
news:A0.25.04075.476F1A84@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx
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!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
