"")
{
echo ''.urldecode($c).'
';
if ($c=='*') $cond="tip='%' AND LEFT(termen,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="tip='%' AND LEFT(termen,1)='".substr($c,0,1)."' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT id,termen,cache_meniu FROM citatepedia WHERE ".$cond." ORDER BY termen", $link ) or die ( "Couldn't select: ".mysql_error() );
if (mysql_affected_rows($link)==0)
{
echo 'No short films starting with '.$c.'.
';
}
else
{
while ( $row = mysql_fetch_array( $result ) )
{
echo ''.$row['termen'].'';
# $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
{
echo 'Short films
';
$cond="tip='%' ".$optiuni['ignoratisql'];
$result = mysql_query( "SELECT COUNT(*) AS _items FROM citatepedia WHERE ".$cond, $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
$items = $row['_items'];
$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";
?>