include "../header_top.php";
include "header_general.php";
echo '
'.$autor_label.'
';
include '../config.php';
$link = mysql_connect( $citatepedia_serv, $citatepedia_user, $citatepedia_pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
else
{
mysql_select_db( $citatepedia_data,$link ) or die ( "Couldn't open database: ".mysql_error() );
include '../meniu_autor.php';
include "../header_content.php";
if ($a<>'')
{
$cond='';
$result = mysql_query( 'SELECT COUNT(*) AS _items FROM citatepedia WHERE tip="l" AND (autor="'.mysql_real_escape_string($a).'" OR compozitor="'.mysql_real_escape_string($a).'" OR interpret="'.mysql_real_escape_string($a).'")', $link ) or die ( "Couldn't select: ".mysql_error() );
$row = mysql_fetch_array( $result );
$items = $row['_items'];
$result = mysql_query( 'SELECT * FROM citatepedia WHERE tip="l" AND autor="'.mysql_real_escape_string($a).'" UNION SELECT * FROM citatepedia WHERE tip="l" AND compozitor="'.mysql_real_escape_string($a).'" UNION SELECT * FROM citatepedia WHERE tip="l" AND interpret="'.mysql_real_escape_string($a).'" ORDER BY calitate DESC,voturi DESC,recomandari DESC,titlu0 LIMIT '.(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() );
echo '
Cântece';
if ($p>1) echo ', pagina '.$p;
echo '
';
include "../show_list.php";
include "../navig.php";
if (strlen($a)>1)
{
$share_title='cântece de '.$autor_label;
$share_description=$metaDescription;
$share_url='http://cantece.citatepedia.ro/de.php?a='.urlencode($a);
$share_center=true;
echo '