Различные вопросы по PHP и MySQL

if (!$id)
    $id = $datauser['manager'];
$q = mysql_query("select * from `m_team` where `id`='" . $id . "'  LIMIT 1;");
$krr = mysql_fetch_assoc($q);
if ($krr['mestorat'] >= 600 && $krr['mestorat'] < 7000)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd8.jpg" alt="lorem">';
if ($krr['mestorat'] >= 500 && $krr['mestorat'] < 600)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd7.jpg" alt="lorem">';
if ($krr['mestorat'] >= 400 && $krr['mestorat'] < 500)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd6.jpg" alt="lorem">';
if ($krr['mestorat'] >= 300 && $krr['mestorat'] < 400)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd5.jpg" alt="lorem">';
if ($krr['mestorat'] >= 200 && $krr['mestorat'] < 300)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd4.jpg">';
if ($krr['mestorat'] >= 100 && $krr['mestorat'] < 200)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd3.jpg">';
if ($krr['mestorat'] >= 30 && $krr['mestorat'] < 100)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd2.jpg">';
if ($krr['mestorat'] >= 0 && $krr['mestorat'] < 30)
echo 'Престиж клуба: <img src="/fmanager/foto/zvezd.jpg"></div>';

<div class="menu r"><a href="/download/sort.php?sort=name">A</a>  
<a href="/download/sort.php?sort=B">B</a>  
<a href="/download/sort.php?sort=C">C</a>  
<a href="/download/sort.php?sort=D">D</a>  
<a href="/download/sort.php?sort=E">E</a>  
<a href="/download/sort.php?sort=F">F</a>  
<a href="/download/sort.php?sort=G">G</a>  
<a href="/download/sort.php?sort=H">H</a>  
<a href="/download/sort.php?sort=I">I</a>  
<a href="/download/sort.php?sort=J">J</a>  
<a href="/download/sort.php?sort=K">K</a>  
<a href="/download/sort.php?sort=L">L</a>  
<a href="/download/sort.php?sort=M">M</a> 
<a href="/download/sort.php?sort=N">N</a>  
<a href="/download/sort.php?sort=O">O</a>  
<a href="/download/sort.php?sort=P">P</a>  
<a href="/download/sort.php?sort=Q">Q</a>  
<a href="/download/sort.php?sort=R">R</a>  
<a href="/download/sort.php?sort=S">S</a>  
<a href="/download/sort.php?sort=T">T</a>  
<a href="/download/sort.php?sort=U">U</a>  
<a href="/download/sort.php?sort=V">V</a>  
<a href="/download/sort.php?sort=W">W</a>  
<a href="/download/sort.php?sort=X">X</a>  
<a href="/download/sort.php?sort=Y">Y</a>  
<a href="/download/sort.php?sort=Z">Z</a>

<hr><a href="/download/sort.php?sort=А">А</a>  
<a href="/download/sort.php?sort=Б">Б</a>  
<a href="/download/sort.php?sort=В">В</a>  
<a href="/download/sort.php?sort=Г">Г</a>  
<a href="/download/sort.php?sort=Д">Д</a>  
<a href="/download/sort.php?sort=Е">Е</a>  
<a href="/download/sort.php?sort=Ж">Ж</a>  
<a href="/download/sort.php?sort=З">З</a>  
<a href="/download/sort.php?sort=И">И</a>  
<a href="/download/sort.php?sort=Й">Й</a>  
<a href="/download/sort.php?sort=К">К</a>  
<a href="/download/sort.php?sort=Л">Л</a>  
<a href="/download/sort.php?sort=М">М</a>  
<a href="/download/sort.php?sort=Н">Н</a>  
<a href="/download/sort.php?sort=О">О</a>  
<a href="/download/sort.php?sort=П">П</a>  
<a href="/download/sort.php?sort=Р">Р</a>  
<a href="/download/sort.php?sort=С">С</a>  
<a href="/download/sort.php?sort=Т">Т</a>  
<a href="/download/sort.php?sort=У">У</a>  
<a href="/download/sort.php?sort=Ф">Ф</a>  
<a href="/download/sort.php?sort=Х">Х</a>  
<a href="/download/sort.php?sort=Ц">Ц</a>  
<a href="/download/sort.php?sort=Ч">Ч</a>  
<a href="/download/sort.php?sort=Ш">Ш</a>  
<a href="/download/sort.php?sort=Щ">Щ</a>  
<a href="/download/sort.php?sort=Э">Э</a>  
<a href="/download/sort.php?sort=Ю">Ю</a>  
<a href="/download/sort.php?sort=Я">Я</a>  
<a href="/download/sort.php?sort=Ё">Ё</a> 
</div>

<?
define('_IN_JOHNCMS', 1);
$textl = 'Taronalar';
require_once ("../incfiles/core.php");
require_once ("../incfiles/head.php");

include_once $SERVER['DOCUMENT_ROOT'].'download/functions.php';
echo'<div class="phdr"><a href="download/index.html">' . $lng['downloads'] . ' </a></div>';
$cat = isset($_GET['cat']) ? intval($_GET['cat']) : 0;
$sort = isset($_GET['sort']) ? $_GET['sort'] : "";

$cat_inf = mysql_query("SELECT * FROM `downpath` WHERE `id` = '" . $cat . "' LIMIT 1"); 
if(mysql_num_rows($cat_inf)){ 
$cat_inf = mysql_fetch_assoc($cat_inf); 
}else{ 
$cat_inf = array('way' => ''); 
}
echo'<div class="menu_gl">';
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `type` != 1 AND `status` = 1 && `way` LIKE '" . $cat_inf['way'] ."%'"), 0);

$zap = mysql_query("SELECT * FROM `downfiles` WHERE SUBSTRING(`name`, 1, 1) = $sort"); 
while ($ok = mysql_fetch_array($zap)) {

$ok['name'] = str_replace('||||','',$ok['name']); 


$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0); 
echo ($i % 2) ? '' :  ''; 
$i; 
$ok['name'] = str_replace('||||','',$ok['name']); 


$new = mysql_result(mysql_query("SELECT COUNT(*) FROM `downfiles` WHERE `time` > '" . (time() - 86400) . "' AND `id` = '" . $ok['id'] . "'"), 0); 
echo'<a href="/download/' . $ok['name'] . '_'.$ok['id'].'.html"><img src="/img/00.png" alt="*"> '.$ok['name'].'
';
if($new > 0){ 
echo'<img src="/images/04.png">';
}else{ 
}
echo'<span class="count">' . size_convert($ok['size']) . '</span></a>';

}


require_once ("../incfiles/end.php");
?>