0) { $query = $query." AND id_subcat_lvl2='".$idsc2."'"; } else { if ($idsc>0) { $query = $query." AND id_subcat='".$idsc."'"; } else { $query = $query." AND id_cat='".$idc."'"; } } $query = $query." AND id_issue NOT IN (SELECT id FROM t_issues WHERE activ ='2')"; $query = $query." ORDER BY year DESC, month DESC LIMIT 1"; $result = mysql_query($query); if (!$result) { die(mysql_error()); } else { $row = mysql_fetch_array($result, MYSQL_ASSOC); $issue = $row['issue']; $id_issue = $row['id2']; $id_art = $row['id1']; $headline = $row['titlu']; $headline2 = $row['subtitlu']; $has_photo = $row['has_photo']; $url = $row['url']; } $query = "SELECT titlu,subtitlu,id FROM t_articol WHERE priority='2' AND id_issue='".$id_issue."'"; if ($idsc2>0) { $query = $query." AND id_subcat_lvl2='".$idsc2."'"; } else { if ($idsc>0) { $query = $query." AND id_subcat='".$idsc."'"; } else { $query = $query." AND id_cat='".$idc."'"; } } $query = $query." ORDER BY RAND() LIMIT 4"; $lista_main4 = mysql_query($query); $query = "SELECT titlu,id FROM t_articol WHERE priority='3' AND id_issue='".$id_issue."'"; if ($idsc2>0) { $query = $query." AND id_subcat_lvl2='".$idsc2."'"; } else { if ($idsc>0) { $query = $query." AND id_subcat='".$idsc."'"; } else { $query = $query." AND id_cat='".$idc."'"; } } $query = $query." ORDER BY RAND()"; $lista10 = mysql_query($query); /* ---------- LISTA 10_2 ----------------------*/ $query = "SELECT titlu,id FROM t_articol WHERE id_issue<>'".$id_issue."' AND id_issue NOT IN (SELECT id FROM t_issues WHERE activ ='2')"; if ($idsc2>0) { $query = $query." AND id_subcat_lvl2='".$idsc2."'"; } else { if ($idsc>0) { $query = $query." AND id_subcat='".$idsc."'"; } else { $query = $query." AND id_cat='".$idc."'"; } } $query = $query." ORDER BY RAND() LIMIT 10"; $lista10_2 = mysql_query($query); ?> <? echo $titlu_pag.' - The Diplomat Bucharest - '.$nr_crt;?>
EVENTS:
The magazine for informed internationals
The Diplomat Bucharest

< back to homepage
'.$headline; ?>

'; } ?>
 
';} echo '

'.$row['titlu'].'

'; echo '

'.$row['subtitlu'].'

'; $i++; } ?>

Previous months articles: