Choose Your Sport From The List Below

idName	Venue	Cost	Quota
86	Basketball	Lakehaven	3	12
72	Cricket	School	5	6
109	Fishing	Lake	8	2
2	Golf	Toukley Golf Course	5	15
102	Skateboarding	lakehaven	3	15
6	Soccer	school	3	5
3	Squash	Lakehaven Sport Centre	7	5
100	Tennis	Charmhaven	5	10
7	Touch Football	school oval	0	10

[ ] has been added to the GHS sport database.
sport id passed is :

Current number registered for each sport

Check that there is room for you to join that sport!

sql value returned is: SELECT sportid,sport_name, COUNT(sport_id) as 'sport_tally', sport_quota FROM choices, sport_list WHERE choices.sport_id = sport_list.sportid GROUP BY sport_name

Sport id	Name	Tally	Quota	Remaining	State
86	Basketball	12	12	0	No
72	Cricket	5	6	1	Yes
109	Fishing	2	2	0	No
2	Golf	6	15	9	Yes
102	Skateboarding	4	15	11	Yes
6	Soccer	9	5	-4	No
3	Squash	5	5	0	No
100	Tennis	3	10	7	Yes
7	Touch Football	8	10	2	Yes

Create New Student Sport Choice
Surname:
First:
Year:
Sport

Choose Your Sport From The List Below

Create New Student Sport Choice

[ ] has been added to the GHS sport database.sport id passed is :

Current number registered for each sport

Check that there is room for you to join that sport!

[ ] has been added to the GHS sport database.
sport id passed is :