Gibbs Posted January 21, 2007 Share Posted January 21, 2007 I noticed that if I get "Name" from a MySQL database the results are different to getting "name". Is it possible to counter this without having to change "Name" or "name" in PHP? Quote Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/ Share on other sites More sharing options...
Ninjakreborn Posted January 21, 2007 Share Posted January 21, 2007 Yes, there is something to change the first letter to capital, or non-capital.Not sure what it was called, if not regular expressions. Quote Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/#findComment-165308 Share on other sites More sharing options...
se1zure Posted January 21, 2007 Share Posted January 21, 2007 you can use a sting modifier to convert all letters to lowercase, all to uppercase, or you can use an ignorecase.I'm not sure about using it in mysl, but I know that ther is something along the lines of:ingnore.case("")Not exact though. Quote Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/#findComment-165313 Share on other sites More sharing options...
hackerkts Posted January 21, 2007 Share Posted January 21, 2007 Hope this helps [url=http://www.php.net/manual/en/function.strtolower.php]strtolower()[/url] Quote Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/#findComment-165388 Share on other sites More sharing options...
bibby Posted January 21, 2007 Share Posted January 21, 2007 [code]# stuff i just ran on mysql 4.1SELECT name FROM table WHERE 1 AND name="[b]myname[/b]";# returns '[b]MyName[/b]' from table.[b]select [/b]name from table where name='banner'# would return [b]Banner[/b][/code] Quote Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/#findComment-165478 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.