Select a letter corresponding to the name of the game you are looking for. An Error has occured, please submit the following information to the admin select distinct SUBSTRING(gamename,1,1) as gameletter from views v, games g where platform_id= and v.game_id = g.game_id and viewtype= order by gameletter You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and v.game_id = g.game_id and viewtype= order by gameletter' at line 1