Forums

PHP

This topic is locked

Display RecordCount of second recordset

Posted 18 Feb 2002 01:00:39
1
has voted
18 Feb 2002 01:00:39 Martin Mitterer posted:
I work with UD4 and PHAkt. Now my problem:
I have one recordset with a repeat region that displays news categories from a mysql-table named "category". I would like to count the news of each category to display them near the category, e.g.:
Actuality (5)
Politic (9)
...
The news are in a second table called "news". There is a field "CategoryID" in both tables. Until now I haven't found a solution to get this work. Hope, someone can help me.
Thank you.

Reply to this topic