[insert_php]

//echo “

Probando php

“;
include(“i3a.inc”);

$cxn = mysqli_connect($host,$user,$password,$dbname)
or die (“couldn’t connect to server”);

mysqli_set_charset($cxn, “utf8″);

$query = “SELECT DISTINCT id,titulo,entidades_participantes,entidad_financiadora,agno_inicio,agno_fin,apellido1,apellido2,nombre FROM z_proyectos_M2BE WHERE agno_fin>2011 AND (es_ip=1 OR responsable_i3a=0) AND alcance<100 GROUP BY id ORDER BY agno_fin DESC "; $result = mysqli_query($cxn,$query) or die ("Couldn't execute query.1"); echo "

“;
$counter=1;

while($row = mysqli_fetch_assoc($result))
{
extract($row);

if ($counter%2 ==0)
{
echo “

“;

}
else
{
echo “

“;
}
$counter++;
}
echo “

$titulo

Participating entities: $entidades_participantes
Funding: $entidad_financiadora
Period: $agno_inicio – $agno_fin
Principal investigator: $nombre $apellido1 $apellido2

$titulo

Participating entities: $entidades_participantes
Funding: $entidad_financiadora
Period: $agno_inicio – $agno_fin
Principal investigator: $nombre $apellido1 $apellido2

“;

[/insert_php]