SomeoneWhoNeedsAnswers
New member
Having a hard time selecting results by first letter / number. Any ideas why this doesn't work?
$query = "SELECT GAME_ID, gameTitle, gameSystem, gameMainPic, SUBSTRING(gameDescription,1,90) FROM games WHERE gameSystem='Nintendo 64' gameTitle LIKE '#%' ORDER BY gameTitle ASC";
$query = "SELECT GAME_ID, gameTitle, gameSystem, gameMainPic, SUBSTRING(gameDescription,1,90) FROM games WHERE gameSystem='Nintendo 64' gameTitle LIKE '#%' ORDER BY gameTitle ASC";