SELECT * FROM PLAYERS WHERE NAME = ''pete' OR '1'='1''
with an error message
There is a syntax error here that has nothing to do with MySQL or injection. Your query breaks down into
' OR '
In the future please include the entire error message if you want some help.