Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 10 Sep 2015, 05:31
André Noberto André Noberto is offline
 
Join Date: Feb 2011
Location: Brazil
Real name: André Noberto
MySQL Query not working

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.
Reply With Quote
  #2  
Old 11 Sep 2015, 06:59
PinkMilk PinkMilk is offline
 
Join Date: May 2010
Real name: Milk Pink
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 ™
Reply With Quote
  #3  
Old 11 Sep 2015, 07:42
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Why not look at the members profile from admincp to find out his userid
Reply With Quote
  #4  
Old 11 Sep 2015, 12:53
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Can you show us the rest of this code you're using? You might be able to better construct the query.
__________________
Looking for ImpEx?
Reply With Quote
  #5  
Old 11 Sep 2015, 15:16
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Reply With Quote
  #6  
Old 11 Sep 2015, 16:55
André Noberto André Noberto is offline
 
Join Date: Feb 2011
Location: Brazil
Real name: André Noberto
Thanks kh99, it worked.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:13.

Layout Options | Width: Wide Color: