need help in recent comment

[asifnayem]

hi i am with another problem. :/
in my blog, i wanted to show the last comment of the blog posts on recent coment section.
ex:

1) aaa commented on 1st blog post(2)
2) ddd commented on 2nd blog post(10)
3) ccc commented on 3rd blog post(1) 

my codes are this:

<?
echo "<div class='sidebar-entry'>";

$result = mysql_query("SELECT * FROM comment order by id desc LIMIT 0,10");
while ($row = mysql_fetch_array($result)) {
$tot = @mysql_num_rows(mysql_query("SELECT bid FROM comment WHERE bid='$row[1]'"));
$writer = @mysql_fetch_array(mysql_query("SELECT * FROM user WHERE id='$row[3]'"));
$blogname = @mysql_fetch_array(mysql_query("SELECT * FROM blog WHERE id='$row[1]'"));
$blogn = htmlspecialchars_decode($blogname[2]);
$writer = htmlspecialchars_decode($writer[4]);
echo "<img class='arrow' src='images/dot_red.gif' alt='»'/> $writer commented on <a class='side' href='blogc.php?id=$row[1]'>$blogn</a>(".$tot.")<br />";
}

echo "<div class='block'></div>";
echo "</div>";
?>

my codes shows all the comments which are the last 10. but i need the last comments of all the blog posts, not the comments of the same post.
my codes shows like this:

1) aaa commented on 1st blog(2)
2) bbb commented on 1st blog(2)
3) ddd commented on 2nd blog(10)
4) ccc commented on 3rd blog(1)
5) nnn commented on 2nd blog(10) 

comment from the same should not come more than once. but i can't make it. please help. i actually feeling shy to seeking help from u guys, coz everytime when i fail to do something i get help from u guys specially something_else. please help to make it work

[subzero]

ORDER BY(last_entry) LIMIT(0,1)

You will need to last add to count reply

[asifnayem]

im sry its not clear to me.

[arnage]

When you use htmlspecialchars_decode() are you sure that you know what it does?

[asifnayem]

When you use htmlspecialchars_decode() are you sure that you know what it does?

actually my blog is on regional language and thats y i have to use htmlspecialchars_decode(). my langs ar like

আমি নআমি ন

so is there any better option to show this kinds of words to make this normal!
and btw, i stil can't solve my problem in recent comment.

[arnage]

No, you don't. In that case feel free to remove that function. Which is your language?
And for comment(s), is that what you want in singular or plural?

[asifnayem]

No, you don't. In that case feel free to remove that function. Which is your language?
And for comment(s), is that what you want in singular or plural?

plural ofcourse comment(S), i can't succeeded to make it. please help bro. and my lang is bengali, if i remove that function the codes are shown on front end. what should do to show it ok?

[something else]

im still a little confused on what you want....
if you want only the last comment to show but having a unique bid then use:

$result = mysql_query("SELECT * FROM comment GROUP BY bid order by id desc LIMIT 0,10"); 

[arnage]

plural ofcourse comment(S), i can't succeeded to make it. please help bro. and my lang is bengali, if i remove that function the codes are shown on front end. what should do to show it ok?

Bengali language is UTF8 also, so first you need to set encoding of the document itself, in Notepad++ that option is "Encoding > Encode in UTF-8 without BOM"

Than in markup, xml:

<?xml version="1.0" encoding="UTF-8"?>

and meta:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>

Those #2438;#2478;#2495; ... simply means that htmlentities() is used on writing and html will parse it into letters without using htmlspecialchars_decode() when encoding is properly set.

[something else]

using htmlspecialchars_decode() can set you up for session stealing for example this could be posted into your comments:
<iframe src="mysite.con/session-stealing-page.php" height="0" width="0" border="0"></iframe>

Added after 6 minutes:

or they could stop the page from being parsed by making loads of html errors eg:
</html><b></u><table><iframe></b><script></iframe><u> etc etc

[asifnayem]

Thanks for this, but i blocked the word iframe/script/html/body/ type words. only youtube link will parse as iframe that is default set. but now i got this problem:

Warning: Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively in Unknown on line 0

[something else]

you have got a error in your script to do with your $_SESSION[] by the sounds of things your trying to set a global variable to it.
you can get rid of that error either by fixing your script or by using 1 of the following:

php.ini

session.bug_compat_42 = 1
session.bug_compat_warn = 0 

.htaccess

php_flag session.bug_compat_42 1
 php_flag session.bug_compat_warn 0 

[asifnayem]

$result = mysql_query("SELECT * FROM comment GROUP BY bid order by id desc LIMIT 0,10"); 

it seems ok for me exept one thing. that is its showing the first comment of every post, but i want last comment of every post.

[something else]

Try:

$result = mysql_query("SELECT a.* FROM comment INNER JOIN (SELECT MAX(id) AS id FROM comment GROUP BY bid) b ON a.id = b.id LIMIT 10"); 

[asifnayem]

not working. getting this error:

PHP Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ......