Pages: [1]
Author Topic: Comments per games  (Read 191 times)
Customers
Full Member
*

Karma: 0
Posts: 32


on: Apr 22, 11, 12:38 PM

Hi,

I would like to add the number of comment on each game.
How i can do that ?

Thks,
Logged
Administrator
Sr. Member
*

Karma: 7
Posts: 486


Email
Reply #1 on: Apr 25, 11, 04:26 AM

In the block's SQL query you should join 2 tables - pas_games & pas_comments, see MySQL docs for LEFTJOIN & JOIN, and count the number of comments, see docs for COUNT keyword in SQL.
Logged
Pages: [1]
 
Jump to: