need help in recent comment

[something else]

does this work?

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

[asifnayem]

does this work?

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

no its not working.

[just_m3.]

no its not working.

supplied argument is not a valid MySQL result resource check if id field exists in your table

[asifnayem]

supplied argument is not a valid MySQL result resource check if id field exists in your table

CREATE TABLE `comment` (
  `id` int(11) NOT NULL auto_increment,
  `bid` int(11) NOT NULL,
  `blogid` int(11) NOT NULL,
  `wid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  `comments` text NOT NULL,
  `time` int(11) NOT NULL,
  `subcomment` int(11) NOT NULL,
  `hasubcomment` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 

my comment table

[something else]

try this: .... if it doesnt work let us know the error

$result = mysql_query("SELECT MAX(id) AS id, bid  FROM comment GROUP BY bid ORDER BY id desc LIMIT 10") OR die(mysql_error()); 

you may need to add a few more row name above ^

[asifnayem]

try this: .... if it doesnt work let us know the error

$result = mysql_query("SELECT MAX(id) AS id, bid  FROM comment GROUP BY bid ORDER BY id desc LIMIT 10") OR die(mysql_error()); 

you may need to add a few more row name above ^

It has no error but the same old thing, showing the first comment of the posts not the last one. i think there should be two order by system.

[asifnayem]

bro, would u plz help?

[something else]

yeah it need a sub query .... i will set up a table on my database and work it out when im more awake ....
had very little sleep past few days :P

[something else]

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

Tested and working

[asifnayem]

thanks :* it works. also i added order by id desc before the limit word.