Fastest Web Hosting

logic to get count of unpaid students in school management system

0 votes
asked Dec 17, 2016 in Mysql by rajatinsa (3,350 points)

I am building a school management system

I want to get the count of students who have not paid

Tables Structure is:

Table1 is : id, student id, payment_date(YYYY-MM_DD)

Table2 is : id, table1 id (fkey), student_name,father_name,mobile

please provide solution..i tried too much

1 Answer

0 votes
answered Mar 6 by anonymous

you can create a variable whose value could be 1 for paid and zero for unpaid for each student and then apply a check in loop for every structured variable for fee

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's