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
|
$DB = new DB;
$concours = $_GET['concours'];
list($lieu, $datef) = explode(' le ',$concours);
list($jour, $mois, $annee) = explode('/', $datef);
$datec = $annee . '-' . $mois . '-' . $jour;
$requete = "SELECT * FROM cso WHERE lieu='" . utf8_encode($lieu) . "' AND datec='" . $datec . "' ORDER by epreuve,classement";
$id = $DB->query($requete);
$row = 0;
while (mysql_fetch_row($id))
{
$cavalier = mysql_result($id, $row, 0);
$cheval = mysql_result($id, $row, 1);
$epreuve = mysql_result($id, $row, 4);
$fautes = mysql_result($id, $row, 5);
$classement = mysql_result($id, $row, 6);
$resultat .= '&cavalier' . $row . '=' .utf8_encode($cavalier);
$resultat .= '&cheval' . $row . '=' . utf8_encode($cheval);
$resultat .= '&epreuve' . $row . '=' . $epreuve;
$resultat .= '&fautes' . $row . '=' . $fautes;
$resultat .= '&classement' . $row . '=' . $classement;
$row++;
}
$resultat .= '&total=' . $row . '&';
echo $resultat;
$DB->close(); |
Partager