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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<style type="text/css">
body, html {font-family:Arial, Helvetica, sans-serif;width:100%;margin:0;padding:0;text-align:center;}
h1 {background-color:#600;color:#fff;padding:20px 0;margin:0;}
a {background-color:#600;color:#fff;padding:20px 0;margin:0;}
a img {border:0;}
td {font-size:11px;}
.image {background-color:#eee;border:1px solid #ddd;border-bottom:1px solid #bbb;padding:5px;}
</style>
<?php
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$sql= "SELECT COUNT(*) AS total FROM combat";
$res = mysql_query('SELECT COUNT(*) AS total FROM combat') OR die(mysql_error());
$row = mysql_fetch_assoc($res);
$nb_id = $row['total'];
mysql_close();
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$sql= "SELECT COUNT(*) AS total01 FROM photo";
$res = mysql_query('SELECT COUNT(*) AS total01 FROM photo') OR die(mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['total01'];
$nb_id1 = $row['total01'];
mysql_close();
?>
<h1>Classement</h1>
<?php
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
//$sql= "SELECT * FROM combat WHERE ID ORDER BY RAND() LIMIT 2";
$sql= "SELECT * FROM photo ";
//$sql = 'SELECT * FROM photo WHERE ID="$idd"';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
$ID[] = $data['ID'];
$nom[] = $data['nom'];
}
// on ferme la connexion à mysql
mysql_close();
//nb_id1 est le nombre total d'ID de photo
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
//$sql= "SELECT * FROM combat WHERE ID ORDER BY RAND() LIMIT 2";
$sql= "SELECT * FROM combat ";
//$sql = 'SELECT * FROM photo WHERE ID="$idd"';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
$win[] = $data['win_id'];
$loose[] = $data['loose_id'];
}
// on ferme la connexion à mysql
mysql_close();
$tt = $nb_id -1;
$bb = $nb_id1 ;
for ($i = 0; $i <= $tt; $i++) {
}
echo count($win, 1)."<br>";
for ($j = 1; $j <= $bb; $j++) {
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$res = mysql_query("SELECT COUNT(*) AS total01 FROM combat WHERE win_id='$j' ") OR die(mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['total01'].' - ' .$j .'<br>';
mysql_close();
}
?>
<br> |
MYSQL problème requéte toute simple
Répondre avec citation
Partager