Show info by first letter of name

[Greaser9780]

I am having difficulty figuring out how to only show a list of gametitle by a givin letter. I used a tutorial found here to get the list broken down by letter using a substring but don't know how to only show certain letters. Here is my code right now:

$gam1 = mysql_query("SELECT gametitle FROM games ORDER BY gametitle ASC") or die(mysql_error());
                             while ($list = mysql_fetch_object($gam1)): 
                $letter = strtoupper(substr($list->gametitle, 0, 1)); 
                if ($prev_row != '0-9' && is_numeric($letter)): 
                    echo '<br /><a gametitle="#number"></a><b><u>0-9</u></b> '; 
                    $prev_row = '0-9'; 
                endif; 
                if ($letter != $prev_row && !is_numeric($letter)): 
                    echo '<br /><a gametitle="'.$letter.'"></a><b><u>'.$letter.'</u></b> ';  
                    $prev_row = $letter; 
                endif; 
                echo $list->gametitle.'<br />'; 
            endwhile; 

[tippy_102]

SELECT gametitle FROM games WHERE gametitle like $letter . '%' ORDER BY gametitle ASC

 

and put your figuring out the letter stuff above it.