kts Posted February 1, 2008 Share Posted February 1, 2008 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 More sharing options...
Barand Posted February 1, 2008 Share Posted February 1, 2008 does echo mysql_error(); give any clues? Link to comment https://forums.phpfreaks.com/topic/88938-solved-problem-with-select-like/#findComment-455524 Share on other sites More sharing options...
kts Posted February 1, 2008 Author Share Posted February 1, 2008 Unfortunately there is no error...... im thinking it has to be something with one of my if statements thats making it bypass improperly. Just wondering if it was a common error, clearly its a booboo on my behalf haha thanks though. Link to comment https://forums.phpfreaks.com/topic/88938-solved-problem-with-select-like/#findComment-455525 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.