Full index of authors
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
"") echo 'Authors beginning with '.$c.'
';
else echo 'Suggested authors
';
$link = mysql_connect( $citatepedia_serv, $citatepedia_user, $citatepedia_pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
else
{
mysql_set_charset('utf8',$link);
mysql_select_db( $citatepedia_data,$link ) or die ( "Couldn't open database: ".mysql_error() );
include_once('../functions.php');
$cacheFile=$citatepedia_path.'/cache_html/'.$home_domain.'_'.md5($_SERVER['REQUEST_URI']);
if(cache_start($cacheFile))
{
if ($c<>"") $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(calitate) AS _vot FROM citatepedia WHERE autor LIKE '".mysql_real_escape_string($c)."%' GROUP BY autor ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
else $result = mysql_query( "SELECT autor,COUNT(*) AS _count,AVG(calitate) AS _vot FROM citatepedia WHERE autor<>'' GROUP BY autor HAVING _count>25 AND _vot>=1.5 ORDER BY autor", $link ) or die ( "Couldn't select: ".mysql_error() );
echo '';
while ( $row = mysql_fetch_array( $result ) )
{
echo '- ';
if ($row['_count']>10?$row['_vot']>=1:false) echo '';
echo ''.$row['autor'].'';
if ($row['_count']>10?$row['_vot']>=1:false) echo '';
echo ' ('.$row['_count'].($row['_count']>1?' quotes':' quote').')
';
}
echo '
';
file_put_contents($cacheFile, ob_get_contents());
ob_end_flush();
}
}
include "../sidebar.php";
include "../footer_general.php";
?>