TECK
04-08-2002, 05:49 AM
i have this code:$newssql=$DB_site->query("SELECT * FROM thread
WHERE forumid='$newsforum'
ORDER BY dateline DESC LIMIT $newsposts");
while ($news=$DB_site->fetch_array($newssql)) {
$newsforumid=$news[forumid];
$newsthreadid=$news[threadid];
$newstitle=$news[title];
$newstime=vbdate($timeformat,$news[dateline]);
$newsdate=vbdate($dateformat,$news[dateline]);
$newsusername=$news[postusername];
$newsuserid=$news[postuserid];
$getnewssql=$DB_site->query_first("SELECT * FROM post
WHERE threadid='$newsthreadid'
ORDER BY postid ASC LIMIT 1");for some strange reason, when i add html code to a post, it will show some extra wierd <br> codes. example:<TABLE BORDER=3 CELLSPACING=3 CELLPADDING=3>
<br />
<br />
<TR>
<br />
<TD BGCOLOR="#1b4465"ALIGN="center" COLSPAN="3">Table</TD>
<br />
</TR>
<br />
<br />
<TR>
<br />
<TD ALIGN="center">Cell</TD>
<br />
<TD ALIGN="center">Cell</TD>
<br />
</TR>
<br />
<br />
</TABLE>let me know please where is it comming from this code and how to rectify this problem.
thanks for taking the time to read this post.
WHERE forumid='$newsforum'
ORDER BY dateline DESC LIMIT $newsposts");
while ($news=$DB_site->fetch_array($newssql)) {
$newsforumid=$news[forumid];
$newsthreadid=$news[threadid];
$newstitle=$news[title];
$newstime=vbdate($timeformat,$news[dateline]);
$newsdate=vbdate($dateformat,$news[dateline]);
$newsusername=$news[postusername];
$newsuserid=$news[postuserid];
$getnewssql=$DB_site->query_first("SELECT * FROM post
WHERE threadid='$newsthreadid'
ORDER BY postid ASC LIMIT 1");for some strange reason, when i add html code to a post, it will show some extra wierd <br> codes. example:<TABLE BORDER=3 CELLSPACING=3 CELLPADDING=3>
<br />
<br />
<TR>
<br />
<TD BGCOLOR="#1b4465"ALIGN="center" COLSPAN="3">Table</TD>
<br />
</TR>
<br />
<br />
<TR>
<br />
<TD ALIGN="center">Cell</TD>
<br />
<TD ALIGN="center">Cell</TD>
<br />
</TR>
<br />
<br />
</TABLE>let me know please where is it comming from this code and how to rectify this problem.
thanks for taking the time to read this post.