FVA/oblast.php at master · ChagovetsSergey/FVA · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?php
	include "config.php";
?>

<!DOCTYPE html>
<html>
	<head>
		<meta charset="cp1251">
		<title>Ôóòáîë â Àõòûðêå</title>
		<link rel="stylesheet" href="http://fva.com.ua/style.css">
	</head>
	<body>

		<?php
			include "header.inc.php";
			include "nav.inc.php";
		?>

		<div id="content">
			<h1 align="center">×åìïèîíàò Ñóìñêîé îáëàñòè ïî ôóòáîëó</h1></br>

			<div id="info">

		 </br>


			<h2>Òóðíèðíàÿ òàáëèöà</h2>
			<table class="grid" cellspacing="0">
				<tr>
    					<th width=20px>ì</th>
        				<th width=130px>êîìàíäà</th>
        				<th width=25px>è</th>
        				<th width=25px>â</th>
        				<th width=25px>í</th>
        				<th width=25px>ï</th>
        				<th width=50px>ì</th>
        				<th width=25px>î</th>
    				</tr>

				<?php
			$sql = "SELECT * FROM obl_table order by p desc";
			$table = mysql_query($sql) or die (mysql_error());

			$i = 0;
			while ($raw = mysql_fetch_assoc($table)){
			$i++;
			$id = $raw['id'];
			$team = $raw['team'];
			$g = $raw['g'];
			$w = $raw['w'];
			$d = $raw['d'];
			$l = $raw['l'];
			$gs = $raw['gs'];
			$gp = $raw['gp'];
			$p = $raw['p'];
			echo "<tr><td>$i</td><td>$team</td><td>$g</td><td>$w</td><td>$d</td><td>$l</td><td>$gs-$gp</td><td>$p</td></tr>";

			}

		?>

			</table></br>


			</div>
			<div id="news">
				<h2>Ëåíòà íîâîñòåé</h2></br>
				<?php
					$sql = "SELECT * FROM news WHERE category='obl' ORDER BY id DESC";
					$news = mysql_query($sql) or die (mysql_error());
					mysql_close();
					while ($raw = mysql_fetch_assoc($news)){
					echo "<a href=\"http://fva.com.ua/showNews.php?id=" . $raw['id'] . "\">" . $raw['title'] . "</a><br><br>";
					}
				?>
			</div>

			<div class="clear"></div>

		</div>

		<?php
			include "footer.inc.php";
		?>
	</body>
</html>