Hjälp

Jag har ett script som man lägger upp matcher.. men jag skulle vilja ha en räknare.. som räknar hur många matcher man har vunnit, förlorat, oavgjorda och totalt spelade matcher.. kan nån hjälpa mig ?

Det hade underlättat lite om du visat lite av din kod så att man kan förstå hur just detta är uppbyggt. ;)

vist ja :P

<?
$section = resultat;
include("header.php");
?>
	<table cellpadding="0" cellspacing="0" width="500" class="content">
			<tr>
				<td>
				<table class="content" width="100%">
					<tr>
						<td><b>Status</b></td>
						<td><b>Datum</b></td>
						<td><b>XonX</b></td>
						<td><b>Motståndare</b></td>
						<td><b>Resultat</b></td>
						<td><b>Map</b></td>
					<td><b>Typ</b></td>
						</tr>
					<br/>
					<?
						$query = mysql_query("SELECT * FROM oboy_matches ORDER BY date DESC");
						while ($row = mysql_fetch_array($query))
						{
						?>
							<tr>
								<td align="center">
								<? if($row["victory"] == "1") 
									{ 
										echo "<img src=img/upp.gif alt=Vinst>";
									} 
									else if($row["victory"] == "2")
									{ 
										echo "&nbsp<img src=img/hoger.gif alt=Oavgjort>";
									}
									else
									{
										echo"<img src=img/ned.gif alt=Förlust>";
									}
								?>
								</td>
								<td><?=date("Y-m-d", $row["date"]);?></td>
								<td><?=$row["type"];?></td>
								<td><?=$row["opponent"];?></td>
								<td><?=$row["result"];?>-<?=$row["result1"];?></td>
								<td><?=$row["map"];?></td>
								<td><?=$row["cb"];?></td>	
						</tr>
						<?
						}
						?>
					</table>
				</td>
			</tr>
		</table>
<?
include("config.php");
?>

//////////////MATCHES/////////////
				else if($menu == "matches")
				{
					if($action == "matches")
					{
						if($opponent && $result && $result1 && $type && $map)
						{
							$datum = time();
							if($result > $result1) 
							{
								$victory = 1;
							}
							else if ($result == $result1)
							{
								$victory = 2;
							}
							else
							{
							$victory = 0;
							}

							$datum = time();

							$query = "INSERT INTO oboy_matches (opponent, result, result1, victory, type, date, map, cb) VALUES ('$opponent','$result', '$result1', '$victory', '$type', '$datum', '$map', '$cb')";
							$result = mysql_query($query) or die ("Ett problem med databasen har uppstått, pröva senare igen.");
	?>
						<tr>
							<td style="vertical-align: top;" width="100%"><br/>Matchen har postats.
							<a href="admin.php">Admin</a></td>
						</tr>
					</table>
				</td>
			</tr>
		</table>
	</tr>
	<?
						}
						else
						{
	?>
							<tr>
								<td style="vertical-align: top;" width="100%"><br/>Du måste fylla i alla fält.
								<a href="<?=$PHP_SELF?>?menu=matches">Tillbaka</a></td>
							</tr>
								</table>
								</td>
							</tr>
					</table>
				</td>
			</tr>
		</table>
			
	<?
						}
					}
				else
				{
				?>
						<form action="<?=$PHP_SELF?>?menu=matches&action=matches" method="post"><br/>
						<tr>
							<td style="vertical-align: top;" width="100">Typ:</td>
							<td style="vertical-align: top;" width="100%">
							<select name="cb">
								<option value="CB">CB</option>
								<option value="R60">R60</option>
								<option value="PCW">PCW</option>
								<option value="CUP">CUP</option>
							</select></td>
						</tr>
						<tr>
							<td style="vertical-align: top;" width="100">Motståndare:</td>
							<td style="vertical-align: top;" width="100%"><input type="text" name="opponent" size="24"></td>
						</tr>
						<tr>
							<td style="vertical-align: top;">Resultat (O.BoY först)</td>
							<td style="vertical-align: top;"><input type="text" name="result" size="10" maxlength=5><input type="text" name="result1" size="10" maxlength=5></td>
						</tr>	
						<tr>
							<td style="vertical-align: top;" width="100">XonX</td>
							<td style="vertical-align: top;" width="100%">
							<select name="type">
								<option value="5on5">5on5</option>
								<option value="4on4">4on4</option>
								<option value="3on3">3on3</option>
								<option value="2on2">2on2</option>
								<option value="1on1">1on1</option>
							</select></td>
						</tr>
						<tr>
							<td style="vertical-align: top;" width="100">Map</td>
							<td style="vertical-align: top;" width="100%"><input type="text" name="map" size="24"></td>
						</tr>
						<tr>
							<td style="vertical-align: top;" width="100"><br/><input type="submit" name="submit" value="Post macth"></td>
						</tr>	
						</form>
						<tr>
							<td><br /><a href="admin.php">Tillbaka</a></td>
						</tr>
					</table>
				</td>
			</tr>
		</table>
			
				<?
				}
			}
				//////////////END OF MATCHES/////////////
					///////////// DELETE MATCHES//////////
				else if($menu == "deletematches")
				{
					if($action == "deletematches")
					{
						$query = mysql_query("DELETE FROM oboy_matches WHERE date=$date") or die("Matchen kunde inte tas bort, försök igen senare.");
					?>
						<tr>
								<td><br/>Matchen har tagits bort.
								<a href="admin.php">Admin</a></td>
							</tr>
						</table>
					</td>
				</tr>
			</table>
					<?
					}
					else
					{
						$query = mysql_query("SELECT * FROM oboy_matches ORDER BY date DESC");
						while ($row = mysql_fetch_array($query))
						{
						?>
						<tr>
							<td>
								<table class="content">
									<tr>
										<td>
											<font color="#5F6877"><b>O.BoY vs <?=$row["opponent"]?></b> <?=$row["result"]?> - <?=$row["result1"]?><br/>
										</td>
										<td>
										<a href="<?=$PHP_SELF?>?menu=deletematches&action=deletematches&date=<?=$row["date"]?>">Ta bort</a>
										</td>
									</tr>
								</table>
							</td>
						</tr>
						<?
						}
						?>
					</table>
				</td>
			</tr>
		</table>
						<?
					}
				}
				//////END OF DELETE MATCHES/////////

Du kan få en räknare efter loopen... genom att göra följande:

if($row["victory"] == "1")
{
	$status['victory']++;
	echo "<img src=img/upp.gif alt=Vinst>";
}
else if($row["victory"] == "2")
{
	$status['draw']++;
	echo "&nbsp<img src=img/hoger.gif alt=Oavgjort>";
}
else
{
	$status['looses']++;
	echo"<img src=img/ned.gif alt=Förlust>";
}
$status['total']++;

sen kan du köra en print_r($status) efter while loopen så ser du vad arrayen innehåller...