|
$sql="select SQL_CACHE * from fotos where fecha>=’$rango’ and caption like ‘%$iden%’ ORDER BY fecha DESC, hora DESC, foto_id DESC”;
$result = mysql_query($sql);
$cont = mysql_num_rows($result);
if ($cont==0)
echo “No existen fotos que coincidan con el criterio de búsqueda dado”;
else{
$notas = array();
while($this = mysql_fetch_array($result)){
array_push($notas, $this);
}
if(($mas+1)==$indices and $mas)
$salto=$cont;
else
{
/* desde aqui quite el 10 */
if (ceil($cont/12)<2)
$salto=$cont;
else
$salto=12+($mas*12);
}
?>
| Pos. |
País |
Oro |
Plata |
Bronce |
Total |
| 1 |
Estados Unidos |
92 |
79 |
66 |
236 |
| 2 |
Cuba |
58 |
35 |
43 |
136 |
| 3 |
Brasil |
48 |
35 |
58 |
141 |
| 4 |
México |
42 |
41 |
50 |
133 |
| 5 |
Canadá |
30 |
40 |
49 |
119 |
| 6 |
Colombia |
24 |
25 |
35 |
84 |
| 7 |
Argentina |
21 |
19 |
35 |
75 |
| 8 |
Venezuela |
12 |
27 |
33 |
72 |
| 9 |
República Dominicana |
7 |
9 |
17 |
33 |
| 10 |
Ecuador |
7 |
8 |
9 |
24 |
| 11 |
Guatemala |
7 |
3 |
5 |
15 |
| 12 |
Puerto Rico |
6 |
8 |
8 |
22 |
| 13 |
Chile |
2 |
17 |
24 |
43 |
| 14 |
Jamaica |
1 |
5 |
1 |
7 |
| 15 |
Bahamas |
1 |
1 |
1 |
3 |
| 16 |
Islas Caimán |
1 |
1 |
1 |
3 |
| 17 |
Antillas Holandesas |
1 |
0 |
1 |
2 |
| 18 |
Costa Rica |
1 |
0 |
0 |
1 |
| 19 |
Uruguay |
0 |
3 |
2 |
5 |
| 20 |
Perú |
0 |
2 |
5 |
7 |
| 21 |
Trinidad y Tobago |
0 |
2 |
2 |
4 |
| 22 |
San Cristóbal y Nieves |
0 |
2 |
0 |
2 |
| 23 |
El Salvador |
0 |
1 |
0 |
1 |
| 24 |
Barbados |
0 |
0 |
2 |
2 |
| 25 |
Bolivia |
0 |
0 |
2 |
2 |
| 26 |
Paraguay |
0 |
0 |
2 |
2 |
| 27 |
Dominica |
0 |
0 |
1 |
1 |
| 28 |
Guyana |
0 |
0 |
1 |
1 |
| 29 |
Panamá |
0 |
0 |
1 |
1 |
| 30 |
Aruba |
0 |
0 |
0 |
0 |
| 31 |
Belice |
0 |
0 |
0 |
0 |
| 32 |
Bermudas |
0 |
0 |
0 |
0 |
| 33 |
Granada |
0 |
0 |
0 |
0 |
| 34 |
Haití |
0 |
0 |
0 |
0 |
| 35 |
Honduras |
0 |
0 |
0 |
0 |
| 36 |
Islas Vírgenes GB |
0 |
0 |
0 |
0 |
| 37 |
Islas Vírgenes EUA |
0 |
0 |
0 |
0 |
| 38 |
Nicaragua |
0 |
0 |
0 |
0 |
| 39 |
Santa Lucía |
0 |
0 |
0 |
0 |
| 40 |
San Vicente Granadinas |
0 |
0 |
0 |
0 |
| 41 |
Surinam |
0 |
0 |
0 |
0 |
| 42 |
Antigua y Barbuda |
0 |
0 |
0 |
0 |
|
if ($hasta-$otro>21){
$otro++;
if ($mas>11)
$otro=$hasta-21;
}
else{
$otro–;
if ($otro<0 or $mas<11)
$otro=0;
else
$otro=$mas-12;
}
?>
|
|