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?
print "";
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]."";
}
print "";
