Jump to content

Archived

This topic is now archived and is closed to further replies.

MOnkman

Problem with select using = instead of like

Recommended Posts

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!!!

Share this post


Link to post
Share on other sites

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%\'\";

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.