Problem with select using = instead of like

[MOnkman]

When using this:

 

$_player_num = 15;

 

$query = \"select * from players where player_num = \'%\".$_player_num.\"%\'\";

 

I get no results however, when using ........player_num like \'......... instead i get a returned result for this but it would also return a result had $_player_num been 5, even though it didnt exist.

 

I am confused and frustrated, please help!!!

[DocSeuss]

You can\'t use wildcards \"%\" in an = SELECT

 

what exactly are you trying to find matches for if it\'s anything with a \'15\' in it use.

 

$query = \"SELECT * FROM palyers WHERE player_num LIKE \'%$_player_num%\'\";