"")
{
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";
?>