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='traducator="'.mysql_real_escape_string($a).'"';
$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 calitate DESC,voturi DESC,recomandari DESC,lungime LIMIT ".(($p-1)*$perpage).','.$perpage, $link ) or die ( "Couldn't select: ".mysql_error() );
echo 'Traduceri de '.$autor_label;
if ($p>1) echo ', pagina '.$p;
echo '
';
include "../show_list.php";
include "../navig.php";
}
}
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>