Top termeni după numărul de definiții
';
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() );
$result = mysql_query( "SELECT termen,COUNT(*) AS _count FROM citatepedia WHERE specie='=' GROUP BY termen ORDER BY _count DESC LIMIT 100", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row = mysql_fetch_array( $result ) )
{
echo ''.$row['termen'].' ('.$row['_count'].' definiții)';
}
}
echo '';
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>