syed Posted September 3, 2006 Share Posted September 3, 2006 Hi guys hope some one can help me out, Im displaying records from my mysql database, getting the records I have no problems with. However when I display the data on my page words with ' get replaced by the ?. Such as if i store the folllowing a table field, Hi I'm fine when I display the data from the table to a page I get Hi I?m fine. Can some one kindly help me out here, is it to do with the way I get my results from my database for is it to do with the SQL syntax? Link to comment https://forums.phpfreaks.com/topic/19542-get-records-from-mysql/ Share on other sites More sharing options...
extrovertive Posted September 3, 2006 Share Posted September 3, 2006 Maybe it's the character encoding of your page?Try UTF-8 as your encoding. Link to comment https://forums.phpfreaks.com/topic/19542-get-records-from-mysql/#findComment-85054 Share on other sites More sharing options...
syed Posted September 4, 2006 Author Share Posted September 4, 2006 Hi thanks for your response.I have another database which has a table and I have text witin the table which consists of quote marks, I am able to view the data from the other database with no problem.The database I am having problems with is the phpbb forum, to be more exact it is the table which contains all the text data. When I try to get data from the table every single and double quote is replaced by a ? mark symbol, does any one know much about magic quotes may be that could be the problem, I have tried reviewing the php file for the phpbb forum (viewtopic.php) which displays messages to see how the code gets the data from the database, I havnt found anything in the file that gives a hint as to what it could be. Link to comment https://forums.phpfreaks.com/topic/19542-get-records-from-mysql/#findComment-85467 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.