Cleopatra
Posts: 73
|
| Posted: 03/29/2010, 6:32 AM |
|
Hey everyone,
I'm trying to build a report based on 3 tables: users, questions, answers.
How do you show the username with the number of answers and the question it belongs to on one row.The function count is used to count the answers, but I get all the users, even the ones who haven't recieved ansers, with the same values as the others. I've tried it with report builder, but don't know exactly what to group together.
Any ideas anyone?
_________________
php newbie |
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 03/29/2010, 11:06 AM |
|
Cleopatra,
We need more information. Could you please give us your table layouts and any queries that you have created. Also, what version of MySQL are you using?
|
|
|
|
Waspman
Posts: 948
|
| Posted: 04/03/2010, 7:48 AM |
|
I'd store the answer count in the db?
_________________
http://www.waspmedia.co.uk |
|
|
|
|
