Hello,

I am trying to produce some summary tables for my site and its membership. I need to have a table for example that displays the number of members at each membership level. To do thi2 I need to run four queries like this one:

SELECT COUNT(*) FROM `this_table` WHERE plan_id=1 and status='A'

How can I integrate four of these results (one for each member level) into a table for display?

Thank you,
Sid.

Hi,

I made some progress on this but still have one thing I can't figure out. I am now producing a table that gives the totals for each level of membership on my site. The final step is to show a grand total for all levels. I would appreciate any help to do this, the only way I see is to have a second table that shows this one row total. Is there a better way?

I am loving this set of products you have, most impressive!
Sid.

Hello,

Sorry for the delay. If you want to use table with sorting feature, total count row should be added as separate control (table), in other case total count row will be sorted with other rows.

Regards,
ARI Soft

Thank you I made a separate table for the total count.
Sid.