hi everyone
got an issue trying to get certain results from a list generated from a database..
ill try and set the scenario
basically i want the same thing as the left hand menu here https://www.elance.com/r/jobs/cat-design-multimedia/
...if you notice at the sides of the categorys theres a value of how many projects are posted, then in the groups theres the total amount for each group.
ive been trying to do this same thing but its drivin me mad. originally ive been trying using php, i then had a friend try with sql, but he got very carried away and started reccomending recoding whole parts of the script...that ended sharply lol.... now im thinkin mybe javascript would be a good idea? but i have not much knowledge of it at all so im stumped...
from the database i have returned the following results...
categorys
groups
all projects posted
i somehow need to check all project categories against site categories, and return a number based on how many projects are found
then i need to calculate how many results are found in that group of categories and return that number
is this possible with js? or a friendly php way?
thanks