\n";
print "Lista de Inscritos em Maratonas
\n";
print "\n";
print " |
\n";
print "|
\n";
$_SESSION['ret2'] = "asespedal_gestao_inscricoes_list.php";
$_SESSION['ret4'] = "asespedal_gestao_inscricoes_list.php";
require_once("mysql_connect.php");
$result = mysql_query("SELECT * FROM inscricoes ORDER BY dorsal;", $link);
while ($row = mysql_fetch_array($result)) {
$dt2 = explode(" ", $row['data_inscricao']);
$dt3 = explode("-", $dt2[0]);
$dti = $dt3[2].'/'.$dt3[1].'/'.$dt3[0];
if ($row['data_pagamento'] == "0000-00-00") {
$dp = "PENDENTE";
$class = "mostra_red";
$bl1 = "";
$bl2 = "";
} else {
$dtemp = explode("-",$row['data_pagamento']);
$dp = $dtemp[2]."/".$dtemp[1]."/".$dtemp[0];
$class = "mostra_green";
$bl1 = "";
$bl2 = "";
}
$mid = $row['marca'];
$result2 = mysql_query("SELECT id,marca FROM marcas WHERE id = $mid;", $link);
$row2 = mysql_fetch_array($result2);
$num_maratona = $row['maratona'];
$result3 = mysql_query("SELECT * FROM maratonas WHERE numero = $num_maratona;", $link);
$row3 = mysql_fetch_array($result3);
$num_maratona = $row3['numero'];
$mid = $row['dorsal'];
$result4 = mysql_query("SELECT * FROM ases WHERE dorsal = $mid;", $link);
$row4 = mysql_fetch_array($result4);
$mid = $row['loja'];
$result7 = mysql_query("SELECT * FROM lojas WHERE id = $mid;", $link);
$row7 = mysql_fetch_array($result7);
print "| ".$row['dorsal']." | ".$row4['nome']." | ".$row3['maratona']." | ".$dti." ".$dt2[1]." | ".$row7['loja']." | ".$row2['marca']." | ".$row['preco_total']." € | ".$row3['preco_dvd']." € | ".$row3['preco_acompanhante']." € | ".$bl1.$dp.$bl2." | Mostrar dados | Alterar dados | Remove Inscrição |
\n";
}
print "| \n";
print "\n";
print "\n";
print " |
\n";
print "