Need to get count -- stuck...

[zzz]

I need to count a variable stored in a database. The problem is that I have data stored in 3 tables. I guess I am just having problems with query syntax.

[Blulagoon]

Are you getting any kind of error message ?

You could also try downloading MySQL Query Browser* and test your query in that environment using a valid value for $my_PUBLICATION_id to check it is retrieving the data you want it to.

HTH - Blu

*available from mysql.com downloads|tools

[zzz]

No error messages. I was getting one until I put GROUP BY in the query. I think I am on the right track, I'm just not sure I'm writin it correctly.

[zzz]

How do I delete this thread? I'd like to post this question on database discussion board.