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()); Quote 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()); Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.