28rain Posted March 4, 2009 Share Posted March 4, 2009 its returning 15��������� when i query this while($row = mysql_fetch_array( $result )) { // My edited version, Using sel_byid $id = stripslashes($row['id']); and then echo $id Thanks Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/ Share on other sites More sharing options...
Mchl Posted March 4, 2009 Share Posted March 4, 2009 Because it's wicked, possessed, mad, crazy, pregnant... well... no idea really, because you did not post the query in question nor any other relevant information (like exemplary data) Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/#findComment-776650 Share on other sites More sharing options...
gnawz Posted March 4, 2009 Share Posted March 4, 2009 What king of data are you getting from the database? Is it HTML page content? To me it looks like there are some characters that can not be displayed. Try editing your data first by rewriting apostrophies, quotes and other symbolic notations like currencies again in an editor like dreamweaver then save it again in the DB or try using http://www.w3schools.com/tags/ref_entities.asp Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/#findComment-776655 Share on other sites More sharing options...
Boo-urns Posted March 4, 2009 Share Posted March 4, 2009 Yea i believe the problem is what gnawz said. The characters aren't being displayed properly. Easy example is pasting text from Word into a textbox and submitting that will produce similar results. Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/#findComment-776659 Share on other sites More sharing options...
28rain Posted March 4, 2009 Author Share Posted March 4, 2009 oh ok yeah i though it was characters not being displayed right i just dont know where they are coming from.... i think maybe from another column in the table that would explain... oh well i'll work round it! Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/#findComment-776668 Share on other sites More sharing options...
Mchl Posted March 4, 2009 Share Posted March 4, 2009 Showing us the query and some data would certainly help us help you Link to comment https://forums.phpfreaks.com/topic/147968-solved-why-is-this-sql-query-posting-lots-of-s/#findComment-776694 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.