[André Noberto]

Hello guys, I'm using the following code to get userid and other stuff from database but everytime a special character like "TM" appears, the query doesn't return any result.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Can you help me with this?

Thanks in advance.

[PinkMilk]

Try & #153; (no space) instead of ™, also run query from phpmyadmin search for partial matches of "LeO" and see how the database has re-encoded the ™

[ForceHSS]

Why not look at the members profile from admincp to find out his userid

[Zachery]

Can you show us the rest of this code you're using? You might be able to better construct the query.

[kh99]

I suspect that it's a character encoding issue, but I don't know much about handling that kind of thing. I did find this page: https://dev.mysql.com/doc/refman/5.0...t-literal.html, so maybe try

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

or maybe _utf8 in place of _latin1.

[André Noberto]

Thanks kh99, it worked.