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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
| <?php require_once('../Connections/kainbuye.php');
$colname_course = "-1";
if (isset($_GET['class'])) {
$colname_course = (get_magic_quotes_gpc()) ? $_GET['class'] : addslashes($_GET['class']);
}
mysql_select_db($database_kainbuye, $kainbuye);
$query_course = "SELECT t1.ID_coureur,
t1.nom,
t1.prenom,
t2.id_categorie,
t2.nom_categorie,
t3.id_club,
t3.nom_cub,
t4.acrho_club_id_club,
t4.acrho_participant_ID_participant,
t4.annee,
t4.dossard,
t4.acrho_categorie_ID_categorie,
t5.id_course,
t5.nom_course,
t5.date,
t5.lieu,
t5.kilometrage,
t5.nbre_part,
t6.ID_classement,
t6.acrho_course_id_course,
t6.ref_dossard,
t6.temps,
t6.moyenne,
t6.point".
"FROM acrho_participant AS t1,
acrho_categorie AS t2,
acrho_club AS t3,
acrho_changement AS t4,
acrho_course AS t5,
acrho_classement AS t6 ".
"WHERE t5.id_course = ".$colname_course." ".
"AND t4.acrho_participant_ID_participant = t1.ID_coureur ".
"AND t4.acrho_categorie_ID_categorie = t2.id_categorie ".
"AND t4.acrho_club_id_club = t3.id_club ".
"AND t6.acrho_course_id_course = t5.id_course ".
"AND t6.ref_dossard = t4.dossard ".
"AND YEAR(t5.date) = t4.annee".
" ".
"ORDER BY t6.temps ASC";
$course = mysql_query($query_course, $kainbuye) or die(mysql_error());
$row_course = mysql_fetch_assoc($course);
$totalRows_course = mysql_num_rows($course);
?> |
