\n";
print "Lista de Inscritos por Nome
\n";
print "\n";
print " |
\n";
print "|
\n";
$_SESSION['ret2'] = "asespedal_gestao_dorsais_list.php";
$_SESSION['ret3'] = "asespedal_usr_lista_inscritos_nome.php";
$_SESSION['ret4'] = "asespedal_usr_lista_inscritos_nome.php";
require_once("mysql_connect.php");
$result6 = mysql_query("SELECT * FROM ases ORDER BY nome;", $link);
while ($row6 = mysql_fetch_array($result6)) {
$mid = $row6['dorsal'];
$result = mysql_query("SELECT * FROM inscricoes WHERE dorsal = $mid AND data_pagamento != '0000-00-00';", $link);
$row = mysql_fetch_array($result);
if (mysql_num_rows($result) != "0") {
$mid = $row['marca'];
$result2 = mysql_query("SELECT id,marca FROM marcas WHERE id = $mid;", $link);
$row2 = mysql_fetch_array($result2);
$mid = $row['maratona'];
$result3 = mysql_query("SELECT * FROM maratonas WHERE numero = $mid;", $link);
$row3 = mysql_fetch_array($result3);
$mid = $row['jersey'];
$result4 = mysql_query("SELECT * FROM jersey WHERE numero = $mid;", $link);
$row4 = mysql_fetch_array($result4);
$mid = $row['jersey_adicional'];
$result5 = mysql_query("SELECT * FROM jersey WHERE numero = $mid;", $link);
$row5 = mysql_fetch_array($result5);
$mid = $row['loja'];
$result7 = mysql_query("SELECT * FROM lojas WHERE id = $mid;", $link);
$row7 = mysql_fetch_array($result7);
print "| ".$row['dorsal']." | ".$row6['nome']." | ".$row7['loja']." | ".$row6['data_nascimento']." | ".$row3['maratona']." | ".$row['acompanhantes']." | ".$row4['jersey']." | ".$row5['jersey']." | ".$row2['']." |
\n";
}
}
print "| \n";
print "\n";
print "\n";
print " |
\n";
print "