<?php require_once('Connections/conexionfisico.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_jugadores = 10;
$pageNum_jugadores = 0;
if (isset($_GET['pageNum_jugadores'])) {
$pageNum_jugadores = $_GET['pageNum_jugadores'];
}
$startRow_jugadores = $pageNum_jugadores * $maxRows_jugadores;
mysql_select_db($database_conexionfisico, $conexionfisico);
$query_jugadores = "SELECT * FROM jugadores ORDER BY jugadores.APELLIDO";
$query_limit_jugadores = sprintf("%s LIMIT %d, %d", $query_jugadores, $startRow_jugadores, $maxRows_jugadores);
$jugadores = mysql_query($query_limit_jugadores, $conexionfisico) or die(mysql_error());
$row_jugadores = mysql_fetch_assoc($jugadores);
if (isset($_GET['totalRows_jugadores'])) {
$totalRows_jugadores = $_GET['totalRows_jugadores'];
} else {
$all_jugadores = mysql_query($query_jugadores);
$totalRows_jugadores = mysql_num_rows($all_jugadores);
}
$totalPages_jugadores = ceil($totalRows_jugadores/$maxRows_jugadores)-1;
mysql_select_db($database_conexionfisico, $conexionfisico);
$query_todos = "SELECT jugadores.APELLIDO FROM jugadores, club, mediciones, v_club_jugadores ORDER BY jugadores.CODIGO_JUGADOR";
$todos = mysql_query($query_todos, $conexionfisico) or die(mysql_error());
$row_todos = mysql_fetch_assoc($todos);
$totalRows_todos = mysql_num_rows($todos);
?>
<style type="text/css">
body,td,th {
font-family: "Courier New", Courier, monospace;
font-size: 16px;
color: #03F;
}
body {
background-color: #FFF;
}
</style>
<form action="" method="get">
<table width="2629" border="1">
<tr bgcolor="#6699FF">
<th width="427" scope="col">Apellido</th>
<th width="139" scope="col">Nacimiento</th>
<th width="127" scope="col">DNI</th>
<th width="468" scope="col">Calle</th>
<th width="61" scope="col">Nro</th>
<th width="129" scope="col">Piso</th>
<th width="92" scope="col"><p>Depto</p></th>
<th width="170" scope="col">Localdiad</th>
<th width="201" scope="col">Provincia</th>
<th width="116" scope="col">Obra Social</th>
<th width="178" scope="col">Email</th>
<th width="197" scope="col">Club</th>
<th width="67" scope="col">Presion</th>
<th width="59" scope="col">Altura</th>
<th width="77" scope="col">Fecha Medicion</th>
<th width="21" scope="col"> </th>
</tr>
</table>
</form>
<?php do { ?>
<table width="2209" border="1" cellspacing="10">
<tr>
<td width="410" scope="col"><div align="left"><?php echo $row_jugadores['APELLIDO']; ?></div></td>
<th width="137" scope="col"><div align="left"><?php echo $row_jugadores['NACIMIENTO']; ?></div></th>
<th width="123" scope="col"><div align="left"><?php echo $row_jugadores['DNI']; ?></div></th>
<th width="461" scope="col"><div align="left"><?php echo $row_jugadores['CALLE']; ?></div></th>
<th width="88" scope="col"><div align="left"><?php echo $row_jugadores['NRO']; ?></div></th>
<th width="88" scope="col"><div align="left"><?php echo $row_jugadores['PISO']; ?></div></th>
<th width="95" scope="col"><div align="left"><?php echo $row_jugadores['DPTO']; ?></div></th>
<th width="147" scope="col"><div align="left"><?php echo $row_jugadores['LOCALIDAD']; ?></div></th>
<th width="142" scope="col"><div align="left"><?php echo $row_jugadores['PROVINICA']; ?></div></th>
<th width="165" scope="col"><div align="left"><?php echo $row_jugadores['OBRA_SOCIAL']; ?></div></th>
<th width="157" scope="col"><div align="left"><?php echo $row_jugadores['EMAIL']; ?></div></th>
<th width="1" scope="col"><div align="left"></div></th>
<th width="1" scope="col"><div align="left"></div></th>
</tr>
</table>
<?php } while ($row_jugadores = mysql_fetch_assoc($jugadores)); ?>
<p> </p>
<p> </p>
<?php
mysql_free_result($todos);
mysql_free_result($jugadores);
?>