jesushax Posted April 6, 2009 Share Posted April 6, 2009 Hi all is the below SQL valid? meaning if the rsult of field Sect1_4 where test it would be TEST? $ERROR = mysql_query("SELECT `Sect1_4`,`CompanyID` FROM tblDirectory2 WHERE `".strtoupper(Sect1_4)."` LIKE '".strtoupper($_POST["Sect1_4"])."%'") or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/152761-sql-change-field-result-to-upper-and-post-results-to-upper/ Share on other sites More sharing options...
sasa Posted April 6, 2009 Share Posted April 6, 2009 $ERROR = mysql_query("SELECT `Sect1_4`,`CompanyID` FROM tblDirectory2 WHERE UPPER(`Sect1_4`) LIKE '".strtoupper($_POST["Sect1_4"])."%'") or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/152761-sql-change-field-result-to-upper-and-post-results-to-upper/#findComment-802286 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.