[insert_php]
global $wpdb;
$sql = ‘select post_content,post_title, post_name,guid,imagen, id ,ingles,frances,portugues,guid, colaborador, colaborador2, colaborador3 from wp_posts where post_type=”post” and tipo=”post” and post_status=”publish” and id in (SELECT object_id FROM wp_term_relationships tr, wp_term_taxonomy tt, wp_terms t where t.term_id=tt.term_id and tt.term_taxonomy_id=tr.term_taxonomy_id and taxonomy=”category” and slug=”jovenes-emprendedores”)order by post_date desc’;

$query = $wpdb->prepare($sql,’foo’);
$results = $wpdb->get_results($query);
$cont=0;
$cont=1;
$contb=0;
$colaborador1=””;
$colaborador2=””;
$colaborador3=””;
$ncolaborador1=””;
$ncolaborador2=””;
$ncolaborador3=””;

//$cont=0;
//while ($row = mysqli_fetch_row($result) /*and $cont<2*/ ){ foreach( $results AS $row ){ $colaborador2=""; $colaborador3=""; $enlace='https://africaactual.com/'.$row->post_name;
$enlace1=’https://africaactual.com/’.$row->post_name;
$foto=’‘.$row->post_title.’‘;
$row->post_content=strip_tags($row->post_content);
$contenido=substr($row->post_content,0,200).’ …
‘;

if($row->colaborador){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador1=$row2->post_title;
$ncolaborador1=$row2->post_name;
}
}
if($row->colaborador2){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador2;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador2=$row2->post_title;
$ncolaborador2=$row2->post_name;
}
}
if($row->colaborador3){
$sql2=’SELECT post_title,post_name from wp_posts where id=’.$row->colaborador3;
$query2 = $wpdb->prepare($sql2,’foo’);
$results2 = $wpdb->get_results($query2);
foreach( $results2 AS $row2 ){
$colaborador3=$row2->post_title;
$ncolaborador3=$row2->post_name;
}
}

if(!empty($row->ingles))
$ingles=”“;
else
$ingles=””;

if(!empty($row->frances))
$frances= ““;
else
$frances=””;

if(!empty($row->portugues))
$portugues= ““;
else
$portugues=””;

$verMas= “Ver más“;

if(($cont-1)%3==0){
if ($contb%2==0){
echo(“

“);
}else{
echo(“

“);
}
$contb++;
}
echo “

$enlace

Por: “;
if($colaborador1)
echo “$colaborador1“;
if($colaborador2)
echo “, $colaborador2“;
if($colaborador3)
echo ” y $colaborador3“;
echo “

$contenido

$verMas $ingles $frances $portugues

“;

$guid=”https://africaactual.com/”.$row->post_name;

echo “

Compartir

“;
echo “

¡Comparte!

$guid

“;
echo “

“;
echo “

“;

if($cont%3==0){
echo “

“;
echo”

Mostrar Mas

“;
}

$cont++;
}
[/insert_php]