med-aldosivimdp/header.php at master · hernan-ramirez/med-aldosivimdp · 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
87
88
89
90
91
92
<!--Inicio Header -->
<table width="751" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="634" class="BackFirstTable"><img src="<? echo $path ?>img/esc_top.gif" width="86" height="42" hspace="23"></td>
    <td width="117" class="BackFirstTable"><img src="<? echo $path ?>img/end_ftable.gif" width="117" height="42"></td>
  </tr>
</table>
<table width="751" border="0" cellpadding="0" cellspacing="0">
  <tr class="BackScnTable">
    <td width="145"><img src="<? echo $path ?>img/esc_mid.gif" width="145" height="16"></td>
    <td class="BackScnTable"><img src="<? echo $path ?>img/h_ultima_fecha.gif" alt="Ultima Fecha" width="69" height="14"></td>
    <td width="20" class="BackScnTable"><img src="<? echo $path ?>img/mid_fline.gif" width="2" height="16" hspace="9"></td>
    <td class="BackScnTable"><img src="<? echo $path ?>img/h_proxima_fecha.gif" alt="Próxima Fecha" width="87" height="16"></td>
    <td width="117"><img src="<? echo $path ?>img/sitio_oficial.gif" alt="Sitio Oficial del Club Atlético Aldosivi" width="117" height="16"></td>
  </tr>
  <tr class="BackThrdTable">
    <td width="145"><img src="<? echo $path ?>img/esc_mid_d.gif" width="145" height="20"></td>
	<?
	$sql = "
	SELECT  c1.alias AS L, p.goles_primer_club, p.goles_segundo_club, c2.alias AS V
	FROM futbol_partidos p
		LEFT JOIN futbol_clubes c1 ON(c1.id = p.id_primer_club)
		LEFT JOIN futbol_clubes c2 ON(c2.id = p.id_segundo_club)
	WHERE fecha_partido < now()
	AND (
	p.id_primer_club = 1
	OR p.id_segundo_club = 1
	)
	ORDER BY fecha_partido DESC
	LIMIT 1
	";
	$result = mysql_query($sql);
	if(mysql_num_rows($result)!=0){
		$row = mysql_fetch_array($result);
		?>
		<td nowrap><? echo $row["L"] . " " . $row["goles_primer_club"] . " - " . $row["goles_segundo_club"] . " " . $row["V"]  ?></td>
		<?
	}
	?>
    <td valign="top"><img src="<? echo $path ?>img/mid_fline_d.gif" width="2" height="18" hspace="9"></td>
	<td width="100%">&nbsp;
	<?
	$sql = "
	SELECT  c1.alias AS L,  c2.alias AS V, DATE_FORMAT(p.fecha_partido, '%e/%c/%y') AS fecha
	FROM futbol_partidos p
		LEFT JOIN futbol_clubes c1 ON(c1.id = p.id_primer_club)
		LEFT JOIN futbol_clubes c2 ON(c2.id = p.id_segundo_club)
	WHERE fecha_partido > now()
	AND (
	p.id_primer_club = 1
	OR p.id_segundo_club = 1
	)
	ORDER BY fecha_partido ASC
	LIMIT 1
	";
	$result = mysql_query($sql);
	if(mysql_num_rows($result)!=0){
		$row = mysql_fetch_array($result);
		?>

    <? echo $row["L"] . " - " . $row["V"] . " [" . $row["fecha"] . "]" ?>

	<?
	}
	?>
	</td>
    <td width="117" align="right"><img src="<? echo $path ?>img/sitio_oficial_d.gif" width="117" height="20"></td>
  </tr>
</table>
<table width="751" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="145"><img src="<? echo $path ?>img/esc_btm.gif" width="145" height="22"></td>
    <td width="21"><img src="<? echo $path ?>img/fantasy_1.gif" width="25" height="22"></td>
    <td><a href="<? echo $path ?>index.php"><img src="<? echo $path ?>img/home.gif" alt="Inicio" width="40" height="22" hspace="0" border="0"></a></td>
    <td><a href="javascript:abrirVentana('<? echo $path ?>institucion.php','INST',503,350);"><img src="<? echo $path ?>img/institucion.gif" alt="Institución" width="75" height="22" hspace="0" border="0"></a></td>
	  <td><a href="<? echo $path ?>index.php?estruc=2"><img src="<? echo $path ?>img/menores.gif" alt="Menores" width="61" height="22" hspace="0" border="0"></a></td>
    <td><a href="<? echo $path ?>plantel/index.php"><img src="<? echo $path ?>img/equipo.gif" alt="Equipo" width="46" height="22" hspace="0" border="0"></a></td>
    <td><a href="<? echo $path ?>campana/index.php	"><img src="<? echo $path ?>img/campana.gif" alt="Campa&ntilde;a" width="58" height="22" border="0"></a></td>
    <td><a href="<? echo $path ?>comunidad.php"><img src="<? echo $path ?>img/comunidad.gif" alt="Comunidad" width="70" height="22" border="0"></a></td>
    <td><a href="http://www.sportsya.com" target="_blank"><img src="<? echo $path ?>img/noti_sya.gif" alt="Noticias en SportsYa" width="133" height="22" border="0"></a></td>
    <td><img src="<? echo $path ?>img/fantasy_2.gif" width="98" height="22"></td>
  </tr>
</table>
<table width="751" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="170" class="BackFrthLine"><img src="<? echo $path ?>img/caa.gif" width="170" height="22"></td>
    <td width="595" class="BackFrthLine"><img src="<? echo $path ?>img/btm_menu_h.gif" width="45" height="22"></td>
    <td width="6" align="right" class="BackFrthLine"><img src="<? echo $path ?>img/btm_menu_h_btm.gif" width="6" height="22"></td>
  </tr>
</table>
<!--Fin Header -->