MySQL Query not working

[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.

$db->query_read("SELECT userid, avatarid, avatarrevision FROM " . TABLE_PREFIX . "user WHERE username = 'LeO?'");

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/en/charset-literal.html, so maybe try

$db->query_read("SELECT userid, avatarid, avatarrevision
FROM " . TABLE_PREFIX . "user WHERE username = _latin1'LeO™'");



or maybe _utf8 in place of _latin1.

[Andr? Noberto]

Thanks kh99, it worked.