Jump to content

[SOLVED] Problem with SELECT LIKE


kts

Recommended Posts

SELECT * FROM V_Providers WHERE Pname LIKE '%b' AND SID = 3

 

is what i get when I echo and the code is

 

$this->query = "SELECT * FROM " . $V_Providers . " WHERE ".$searchtype." LIKE '%".$state."' AND SID = ".$serviceid."";

 

the dilema is i paste the echo into phpmyadmin and it works, but when executed in php it does not show any results

 

i believe it would have to be syntax, anyone?

Link to comment
https://forums.phpfreaks.com/topic/88938-solved-problem-with-select-like/
Share on other sites

Archived

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

×
×
  • Create New...

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.