<?php
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");

include '../database.php';


$ROW = _QUERY("SELECT EPI000.id, (EPI000.nombre1 + ' ' + EPI000.nombre2) AS nombre , EPI000.apellido1, EPI000.apellido2, EPI000.email,EPI000.telefono, EPI000.estado
FROM EPI000;");
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>EPICOH-NEUREOH REPORTES</title>
<meta http-equiv="Content-Type" content="text/html;" charset="iso-8859-1" />
<link rel="stylesheet" type="text/css" href="../imagenes/estilo.css">
<script>
function lolo(btn){
	btn.disabled = true;
	document.formulario.submit();
}
</script>
</head>
<body topmargin="0" leftmargin="0">
<br>
<table align="center" cellpadding="0" cellspacing="0">
<tr>
    <td class="td1"></td><td class="td2"><b>Participantes:</b></td><td class="td3"></td>
</tr>
<tr>
    <td rowspan="3" class="td4"></td><td height="5px"></td><td rowspan="3" class="td5">
</tr>
<tr><td>
	<table align="center" border="1" cellpadding="1" cellspacing="1" style="padding:2px;">
	<tr>
		<td style="font-weight:bold">ID</td>
		<td style="font-weight:bold">Apellido 1</td>
		<td style="font-weight:bold">Apellido 2</td>
		<td style="font-weight:bold">Nombre</td>
		<td style="font-weight:bold">Email</td>
		<td style="font-weight:bold">Tel&eacute;fono</td>
		<td style="font-weight:bold">Estado</td>
	</tr>
	<? for($i=0;$i<count($ROW);$i++){ ?>
	<tr>	
		<td><?=$ROW[$i]['id'] ?></td>
		<td><?=$ROW[$i]['apellido1'] ?></td>
		<td><?=$ROW[$i]['apellido2'] ?></td>
		<td><?=$ROW[$i]['nombre'] ?></td>
		<td><?=$ROW[$i]['email'] ?></td>
		<td><?=$ROW[$i]['telefono'] ?></td>
		<td><?=$ROW[$i]['telefono'] == '1' ? 'Pagó' : 'Pendiente'?></td>
	</tr>
	<? } unset($ROW); ?>
	</table>
</td></tr>
<tr align="center"><td height="5"></td></tr>
<tr>
    <td class="td6"></td><td class="td7"></td><td class="td8"></td>
</tr>
</table>
<br>
</body>
</html>