Hi everyone, I hope you are well.
Come across this forum as a way of looking for the best solution to store, edit and output the values in a DB.
I run a charity at Christmas time and we get lots of referrals in to support children and adults.
I want to keep a list of ages 0-15 and then 16+, against sex "Male","Female"
The list ultimately will show me how many of each age against each sex.
I want to publicly display this information. Then I want people to sign up and they will enter a quantity against the age/sex they want to help.
So they may have a grid
Age | Male | Female
They'll increase the number against Female aged 3 and Male aged 10 to say they'll help these people. Once they submit, the main website will calculate the new value against who's committed to helping.
I.e. if we have a row in another table, the sum of male aged 10 will reduce from the requirement for male aged 10 and tell me how many are left still needing help.
Embarrassingly, I am used to PHP and have developed PHP systems myself. But this is an important project that I just don't want to get wrong. I want it to be efficient and I thought, may aswell ask what you guys thing first on ideas how best to achieve this?
I'm also not sure I've ever done a form that uses a grid format like this in the past?
What is the best method to output the count in the same grid format above, I guess a function would do it best?
Thank you so much - as you can see, totally rabbiting on but want to get this working in the most efficient way and there's so many clever people out there.
Thank you 🙂