Select language: | |
CMS Eventos

[evalphp]
$dbhost = ‘localhost’;
$dbuser = ‘cmspeopl_admin’;
$dbpass = ‘cmspeople’;

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (‘Ocurrió un error al conectarse al servidor mysql’);

$dbname = ‘cmspeopl_eventos_eng’;
mysql_select_db($dbname);

// Variables de búsquedas de eventos por pais
$todos = mysql_query(“SELECT * from `eventos-2` WHERE `tipo_evento`=’T’ order by `fecha`”);
$colombia = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Colombia’ and `tipo_evento`=’T’ order by `fecha`”);
$espana = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Spain’ and `tipo_evento`=’T’ order by `fecha`”);
$argentina = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Argentina’ and `tipo_evento`=’T’ order by `fecha`”);
$chile = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Chile’ and `tipo_evento`=’T’ order by `fecha`”);
$portugal = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Portugal’ and `tipo_evento`=’T’ order by `fecha`”);
$brasil = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Brazil’ and `tipo_evento`=’T’ order by `fecha`”);
$usa = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’USA’ and `tipo_evento`=’T’ order by `fecha`”);
$polonia = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’poland’ and `tipo_evento`=’T’ order by `fecha`”);
$peru = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Peru’ and `tipo_evento`=’T’ order by `fecha`”);
$paraguay = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Paraguay’ and `tipo_evento`=’T’ order by `fecha`”);
$uruguay = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Uruguay’ and `tipo_evento`=’T’ order by `fecha`”);
$rusia = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Russia’ and `tipo_evento`=’T’ order by `fecha`”);
$francia = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’France’ and `tipo_evento`=’T’ order by `fecha`”);
$ecuador = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Ecuador’ and `tipo_evento`=’T’ order by `fecha`”);
$mexico = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Mexico’ and `tipo_evento`=’T’ order by `fecha`”);
$venezuela = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Venezuela’ and `tipo_evento`=’T’ order by `fecha`”);
$costarica = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Costa Rica’ and `tipo_evento`=’T’ order by `fecha`”);
$portugal = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Portugal’ and `tipo_evento`=’T’ order by `fecha`”);
$bolivia = mysql_query(“SELECT * from `eventos-2` WHERE `pais`=’Bolivia’ and `tipo_evento`=’T’ order by `fecha`”);

// DIV TODOS
echo “

“;
echo “

“;
echo “

Next trainings

“;
echo “

“;

while($row = mysql_fetch_array($todos))
{
echo “

“;
echo “

“;
echo “

“;
echo “

“;
}
echo “

” . $row[‘titulo’] . “
” . $row[‘fecha_txt’] . ” | ” . $row[‘pais’] . ” | ” . $row[‘ciudad’] . “

“;
echo “

“;
$row = mysql_data_seek($todos,0);

// DIV COLOMBIA
echo “

“;
echo “

“;

// DIV ESPAÑA
echo “

“;
echo “

“;

// DIV CHILE
echo “

“;
echo “

“;

// DIV ARGENTINA
echo “

“;
echo “

“;

// DIV PORTUGAL
echo “

“;
echo “

“;

// DIV BRASIL
echo “

“;
echo “

“;

// DIV USA
echo “

“;
echo “

“;

// DIV POLONIA
echo “

“;
echo “

“;

// DIV PERU
echo “

“;
echo “

“;

// DIV PARAGUAY
echo “

“;
echo “

“;

// DIV URUGUAY
echo “

“;
echo “

“;

// DIV RUSIA
echo “

“;
echo “

“;

// DIV FRANCIA
echo “

“;
echo “

“;

// DIV ECUADOR
echo “

“;
echo “

“;

// DIV MEXICO
echo “

“;
echo “

“;

// DIV VENEZUELA
echo “

“;
echo “

“;

// DIV COSTA RICA
echo “

“;
echo “

“;

// DIV PORTUGAL
echo “

“;
echo “

“;

// DIV BOLIVIA
echo “

“;
echo “

“;
[/evalphp]