CODE
<?
include ("php-scripts/connect.php");
?>
<MTComments lastn="10" sort_order="descend">
<$MTCommentAuthorLink spam_protect="1" $> said <a href="<$MTBlogArchiveURL$><$MTCommentEntryID pad="1"$>.php#<MTCommentID>"><$MTCommentBody remove_html="1" trim_to="15"$>...</a> (total comments:
<?
$qryCmt = sprintf("SELECT COUNT(*) as count FROM mt_comment WHERE comment_blog_id=1 AND comment_author='%s' AND comment_url='%s' AND comment_email='%s';",htmlentities ("<$MTCommentAuthor encode_php="qq"$>"), "<$MTCommentURL$>", "<$MTCommentEmail$>");
$reslt = mysql_query($qryCmt);
$rw = mysql_fetch_array($reslt );
echo $rw['count'];
?>)<br />
</MTComments>
include ("php-scripts/connect.php");
?>
<MTComments lastn="10" sort_order="descend">
<$MTCommentAuthorLink spam_protect="1" $> said <a href="<$MTBlogArchiveURL$><$MTCommentEntryID pad="1"$>.php#<MTCommentID>"><$MTCommentBody remove_html="1" trim_to="15"$>...</a> (total comments:
<?
$qryCmt = sprintf("SELECT COUNT(*) as count FROM mt_comment WHERE comment_blog_id=1 AND comment_author='%s' AND comment_url='%s' AND comment_email='%s';",htmlentities ("<$MTCommentAuthor encode_php="qq"$>"), "<$MTCommentURL$>", "<$MTCommentEmail$>");
$reslt = mysql_query($qryCmt);
$rw = mysql_fetch_array($reslt );
echo $rw['count'];
?>)<br />
</MTComments>
I forgot what it's called .. heh ... anywho, I changed my archive format and now I am getting 404 errors because the links to the comments has changed but it didn't update with this script. any ideas on how to fix this ? thx once again for your help
