Hello:

I'm very new to MySQL and I need to count 2 columns in the same table... and display the totals.

1) How many students are registered in a class?
Column name: `register_status` varchar (10), Values= registered, pending, Null = Yes
Count (table.registered) as Enrolled
2) How many students completed a class?
Colum name: `completion_status` varchar (10), Values= Incomplete, Complete, Null = Yes
Count (table.complete) as Finished
I tried 2 counts in the table but I get the same totals on both columns.
Any help will be greatly apreciated!
Thank you.

1)


2)


Hope that helps

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Thank you Andy!

Hello again, MySQL is more challenging than what I expected. From the following table:

Class_ID . . . . Student_ID . . . . Register_Status . . . . Completion_Status
---------------------------------------------------------------------------------
11111 . . . . . . 12345 . . . . . . . . registered . . . . . . . . . Complete
11111 . . . . . . 67890 . . . . . . . . registered . . . . . . . . Incomplete
22222 . . . . . . 12121 . . . . . . . . registered . . . . . . . . . Complete
22222 . . . . . . 23345 . . . . . . . . registered . . . . . . . . No Show
33333 . . . . . . 56789 . . . . . . . . registered . . . . . . . . N/A
44444 . . . . . . 78910 . . . . . . . . registered . . . . . . . . Incomplete

I need to get the Completion_Status count of 'Complete' and I also need to show the number (Count) of registered students that have not completed the class. I need the output to show like below:

Class_ID . . . . Student_ID . . . . Enrolled . . . . . . . . . . Finished
---------------------------------------------------------------------------------
11111 . . . . . . 12345 . . . . . . . . . . . . . . . . . . . . . . . 1
11111 . . . . . . 67890 . . . . . . . . 1 . . . . . . . . . . . . . . .
22222 . . . . . . 12121 . . . . . . . . . . . . . . . . . . . . . . . 1
22222 . . . . . . 23345 . . . . . . . . 1 . . . . . . . . . . . . . . .
33333 . . . . . . 56789 . . . . . . . . 1 . . . . . . . . . . . . . . .
44444 . . . . . . 78910 . . . . . . . . 1 . . . . . . . . . . . . . . .
---------------------------------------------------------------------------------
Total . . . . . . . . . . .. . . . . . . . . 4 . . . . . . . . . . . . . . 2

I tried different things in MySQL but I cannot do it. I can get the output right in the Finished column but I cannot do it in the Enrolled column. Thank you in advance if you can help me to solve this problem!
rafermo