"") { echo '

'.$title.'

'; if ($c=='*') $cond="citatepedia.tip='v' AND LEFT(titlu,1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') ".$optiuni['ignoratisql']; else $cond="citatepedia.tip='v' AND LEFT(titlu,1)='".substr($c,0,1)."' ".$optiuni['ignoratisql']; $result = mysql_query( "SELECT id,titlu,autor,cache_meniu FROM citatepedia WHERE ".$cond." ORDER BY titlu", $link ) or die ( "Couldn't select: ".mysql_error() ); if (mysql_affected_rows($link)==0) { echo '

No poems starting with '.$c.'.

'; } else { while ( $row = mysql_fetch_array( $result ) ) { echo '
  • '.$row['titlu'].' by '.$row['autor'].''; # $result_lang = mysql_query( "SELECT id FROM citatep_citatepedia.citatepedia WHERE id_eng=".$row['id']." LIMIT 1", $link ) or die ( "Couldn't select: ".mysql_error() ); # $row_lang = mysql_fetch_array( $result_lang ); # if ($row_lang['id']>0) echo ' (In Romanian)'; echo $row['cache_meniu']; echo '
  • '; } echo '

    '; } include '../module_ad3.php'; } else { if ($_SERVER['REQUEST_URI']=='/') { include_once('../functions.php'); $cond_plus=''; $cond="citatepedia.tip='v' AND voti>0 AND vote>0 ".$optiuni['ignoratisql']; $sarbatori_cond="citatepedia.tip='v'"; include '../common_anniversary.php'; include '../sarbatori.php'; $subiect='poetry'; include '../despre.php'; include '../content_separator.php'; echo '

    '.$title.'

    '; $result = mysql_query( 'SELECT * FROM citatepedia WHERE '.$cond.' ORDER BY RAND() LIMIT 3', $link ) or die ( "Couldn't select: ".mysql_error() ); include "../show_list.php"; echo '

    '.$ui_text['latest_poems'].'...

    '; include '../module_ad3.php'; } else { echo '

    '.$title.'

    '; $cond="tip='v' ".$optiuni['ignoratisql']; $items = 10*$perpage; $result = mysql_query( "SELECT * FROM citatepedia WHERE ".$cond." ORDER BY dataora DESC LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() ); include "../show_list.php"; include '../module_ad3.php'; include "../navig.php"; } } } include "../sidebar.php"; mysql_close( $link ); include "../footer_general.php"; ?>