Алфавит исполнителей

$page = $_GET['page'];
$meta_title = _SITENAME." - ".$lang['artist'];
$meta_description = "";
$list_cats = list_categories(0, '');
if(!isset($_GET['letter']) || mb_strlen($_GET['letter']) != 1 || !ctype_alnum($_GET['letter'])){
    //Assume we want to show anything non a-z
    $criteria = " REGEXP '^[0-9]'";
}else{
    //We have a valid input letter
    $criteria = " LIKE '".secure_sql($_GET['letter'])."%'";
}
//Check if we use SEO
if($use_seo == true && _SEOMOD == 1){
    $pageurl = 'artists/';
}else{
    $pageurl = 'artists.php';
}
$query = 'SELECT artist,count(*) FROM pm_videos WHERE artist '.$criteria.' GROUP BY artist';
$res = mysql_query($query);
$rows = mysql_num_rows($res);
if($rows > 0){
    $max = ceil($rows/3);
    $i=0;
    $out = "<div style='float:left;width:33%;'>";
    while(list($artist,$numvids) = mysql_fetch_row($res)){
        if($use_seo == true && _SEOMOD == 1){
            $out.= '<a href="'._URL.'/artist/'.urlencode($artist).'/">'.$artist.'  <img src="'._URL.'/images/go.gif" /></a><br />';
        }else{
            $out.= '<a href="'._URL.'/artist.php?artist='.urlencode($artist).'">'.$artist.'  <img src="'._URL.'/images/go.gif" /></a><br />';
        }
        if(++$i >= $max){ $out.="</div><div style='float:left;width:33%;'>"; $i=0; }
    }
    $out.="</div>";
}else{
    
    $out = 'Sorry, no artists were found with this letter';
}

$result = mysql_query('SELECT * FROM `staffs`ORDER BY name') or die(mysql_error($link));

$query = 'SELECT artist,count(*) FROM pm_videos WHERE artist '.$criteria.' GROUP BY artist';

SELECT artist,count(*) FROM

SELECT * FROM

$criteria = " REGEXP '^[0-9]'"

$criteria = " LIKE '".secure_sql($_GET['letter'])."%'";