| SELECT t2.id, |
| t2.filename, |
| t2.name, |
| t1.id_author, |
| t1.id_song |
| FROM `svaz` AS t1 |
| LEFT JOIN `files` AS t2 ON (t2.id = t1.id_song) |
| WHERE t1.id_author = '$id' |
| span style="color: #0000BB"><?phpforeach(array('А', 'Б', 'В', 'Г', 'Д', 'Е', 'Ё', 'Ж', 'З', 'И', 'Й', 'К', 'Л', 'М', 'Н', 'О', 'П', 'Р', 'С', 'Т', 'У', 'Ф', 'Х', 'Ц', 'Ч', 'Ш', 'Щ', 'Э', 'Ю', 'Я', '0-9') AS $value) echo '<a href="'.$config['url'].'/letter.php?let='.rawurlencode($value).'">'.$value.'</a> '; echo '<br/>'; foreach(range('A', 'Z') AS $value) echo '<a href="'.$config['url'].'/letter.php?let='.rawurlencode($value).'">'.$value.'</a> '; |
| span style="color: #0000BB"><?phpif($i==7) echo '<br />'; |
| span style="color: #0000BB"><?phpecho <<<LINK<a href="?page=name&name=0-9">0-9</a><br><a href="?page=name&name=%D0%90">А</a><a href="?page=name&name=%D0%91">Б</a><a href="?page=name&name=%D0%92">В</a><a href="?page=name&name=%D0%93">Г</a><a href="?page=name&name=%D0%94">Д</a><a href="?page=name&name=%D0%95">Е</a><a href="?page=name&name=%D0%96">Ж</a><a href="?page=name&name=%D0%97">З</a><a href="?page=name&name=%D0%98">И</a><a href="?page=name&name=%D0%9A">К</a><br><a href="?page=name&name=%D0%9B">Л</a><a href="?page=name&name=%D0%9C">М</a><a href="?page=name&name=%D0%9D">Н</a><a href="?page=name&name=%D0%9E">О</a><a href="?page=name&name=%D0%9F">П</a><a href="?page=name&name=%D0%A0">Р</a><a href="?page=name&name=%D0%A1">С</a><a href="?page=name&name=%D0%A2">Т</a><a href="?page=name&name=%D0%A3">У</a><a href="?page=name&name=%D0%A4">Ф</a><br><a href="?page=name&name=%D0%A5">Х</a><a href="?page=name&name=%D0%A6">Ц</a><a href="?page=name&name=%D0%A7">Ч</a><a href="?page=name&name=%D0%A8">Ш</a><a href="?page=name&name=%D0%A9">Щ</a><a href="?page=name&name=%D0%AD">Э</a><a href="?page=name&name=%D0%AE">Ю</a><a href="?page=name&name=%D0%AF">Я</a><a href="?page=name&name=%D0%81">Ё</a><br><a href="?page=name&name=a-z">a-z</a><br><a href="?name=zhanr">Жанры саундтреков</a></br>LINK; |
