1
I use flashChat and I am trying to make a block that shows the recent chat topics. here's what I have so far but is shows any chat lines that have a ' in them instead with '
Any idea how I can get rid of that?
le="color: #000000"><?php print "<font size='1'>"; global $xoopsDB; $sql="SELECT COUNT(id) FROM `xoops_messages` WHERE xoops_messages.command = 'msg'"; $result = $xoopsDB->query($sql); $row = mysql_fetch_array($result); $start=$row[0]-5; $sql="SELECT xoops_users.uname, `txt` FROM `xoops_messages` INNER JOIN xoops_users ON xoops_messages.userid = xoops_users.uid WHERE xoops_messages.command = 'msg' ORDER BY xoops_messages.created ASC LIMIT ".$start." , 5"; $result = $xoopsDB->query($sql); while ($row = mysql_fetch_array($result)) { print $row[0].":".$row[1]."<br />"; } print "</font>";
