'; // $sql = "SELECT * FROM Authors order by Name"; $result=mysql_query($sql);?>

'.$code.'
'; for($i=0; $i<$tempN; $i++) { $temp=mysql_result($result,$i,'id'); $name=mysql_result($result,$i,"Name"); if ($name[0]==$code) {echo "" ; echo mysql_result($result,$i,"Name")."
"; echo "
";}; } //алфавитный указатель echo '
'; echo '
'; echo '' ; $sql="SELECT SUBSTR(TRIM(Name),1,1) as firstletter from Authors GROUP BY firstletter"; $res = mysql_query($sql); while($l = mysql_fetch_array($res,MYSQL_ASSOC)) { if ($l["firstletter"]!=$code) echo "".$l["firstletter"]." | "; else echo "".$l["firstletter"]." | "; } echo ''; echo '
'; echo '
'; ?>