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? 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. 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. 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] 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] Link to comment https://forums.phpfreaks.com/topic/35041-upperlowercase-in-mysqlphp/#findComment-165478 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.