I have the following text in my news table in mysql:
Twitvid Revamps to Become an ‘Open YouTube’
It Won’t Be Easy for Iran to Dissect, Copy U.S. Drone
but when it display it will display as symbol as you can see in the attached image or if you go to www.JassimRahma.com where you can see more examples.
what could be the reason and how can I fix it?
here is my code to read from the database
<?php
$conn = mysql_connect('mysql.jassimrahma.com', 'xxxxxxx', 'xxxxxxx');
mysql_select_db("jassimrahma", $conn);
$result = mysql_query("SELECT news_id, news_title, date_format(created_date, '%d %M %Y') as 'news_date' FROM news ORDER BY created_date DESC, news_id DESC", $conn);
$affected_rows = mysql_num_rows($result);
echo "<table width='100%' cellpadding='3' cellspacing='3'>";
while ($i < $affected_rows)
{
$news_id = mysql_result($result, $i ,"news_id");
$news_title = mysql_result($result, $i ,"news_title");
$created_date = mysql_result($result, $i ,"news_date");
echo "<tr>";
echo "<td align='center' valign='top'>";
echo "<img src='http://www.jassimrahma.com/images/news_arrow.jpg' alt='Jassim.com News' />";
echo "</td>";
echo "<td align='left' valign='top'>";
echo "<a href='http://www.JassimRahma.com/$news_id' target='_blank'>$news_title</a>";
echo "</td>";
echo "</tr>";
$i++;
}
echo "<tr><td align='center' valign='top'></td><td align='left' valign='top'><a href='http://www.JassimRahma.com/news' target='_self'><img src='images/more_news.jpg' alt='Technology News - JassimRahma.com' /></a></td></tr>";
echo "</table>";
?>
