1
yyvonne
CBB "GROUP BY"
  • 2009/2/9 3:02

  • yyvonne

  • Just popping in

  • Posts: 38

  • Since: 2008/4/4 2


For the block of CBB, if I have a member replied to a post, it will show RE:...

For example:

If the original post is
"Question about something"

and a replied to this post will show
"RE: Question about something"

If there are 10 replies, my last 10 post will all be the same:
"RE: Question about something"
"RE: Question about something"
"RE: Question about something"
"RE: Question about something"
"RE: Question about something"
....

Is there a way to group the topic up to a single post in the block?

Something like:
GROUP BY p.topic_id

Please help, thank you.

2
DarinAllan
Re: CBB "GROUP BY"

Look for a block called "Recent Topics" in the list of blocks generated by CBB/Forum, I think that's what you want.

;o)

3
yyvonne
Re: CBB "GROUP BY"
  • 2009/2/9 5:17

  • yyvonne

  • Just popping in

  • Posts: 38

  • Since: 2008/4/4 2


I think I should add "GROUP BY p.topic_id" to newbb/blocks/newwbb_block.php

But I tried, failed.

4
ghia
Re: CBB "GROUP BY"
  • 2009/2/9 11:36

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


What is the query, you want to modify?
If you use the group by clause, you can only have the fields from the group by clause or aggregate functions on the other fields in your value list to retrieve.

Login

Who's Online

148 user(s) are online (87 user(s) are browsing Support Forums)


Members: 1


Guests: 147


heyula,

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits