"")
{
echo ''.$title.'
';
if ($c=='*') $cond="citatepedia.tip='l' 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='l' AND titlu LIKE '".substr($c,0,1)."%' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT id,titlu,autor,compozitor,interpret FROM citatepedia WHERE ".$cond." ORDER BY titlu", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_affected_rows($link)==0)
{
echo 'No songs starting with '.$c.'.
';
}
else
{
while ( $row = mysql_fetch_array( $result ) )
{
echo ''.$row['titlu'].'';
if ($row['interpret']<>'')
{
echo ', performed by '.$row['interpret'].'';
if ($row['featuring']<>'')
{
echo ', featuring '.$row['featuring'].'';
}
}
if ($row['compozitor']<>'')
{
echo ', music by '.$row['compozitor'].'';
}
if ($row['autor']<>'')
{
echo ', lyrics 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 '';
}
echo '
';
}
include '../module_ad3.php';
}
else
{
if ($_SERVER['REQUEST_URI']=='/')
{
include_once('../functions.php');
$cond_plus='';
$cond="citatepedia.tip='l' AND voti>0 AND vote>0 ".$optiuni['ignoratisql'];
$sarbatori_cond="citatepedia.tip='l'";
include '../common_anniversary.php';
include '../sarbatori.php';
$subiect='music';
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_songs'].'...
';
include '../module_ad3.php';
}
else
{
echo ''.$title.'
';
$cond="tip='l' ".$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";
?>