The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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.
PHP Code:
Thanks in advance. |
#2
|
|||
|
|||
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 ™
|
#3
|
|||
|
|||
Why not look at the members profile from admincp to find out his userid
|
#4
|
||||
|
||||
Can you show us the rest of this code you're using? You might be able to better construct the query.
|
#5
|
|||
|
|||
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
PHP Code:
|
Благодарность от: | ||
TheLastSuperman |
#6
|
|||
|
|||
Thanks kh99, it worked.
|
Благодарность от: | ||
TheLastSuperman |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|