I am making a site where members are acredited points for submitting something (ex. Article, Lesson, etc) Whenever their name is displayed on the site, I want to have the number of points the user has in parenthesis.
ex . Jeremy F (234)
The problem is : I have several different resources that can be submitted in different tables ( Lessons, Articles, Reviews, etc) This is done because the content of each resource is unique. In each resource table for a submission I will have a UserID (the person who subitted the resource)
Is there anyway I can make a new table that has columns
UserID (member)
LessonPoints (number of points from lessons)
ReviewPoints (number of points from lessons)
The php script that displays the points would add these two variables to get the number of points. However, how do I set it up so that LessonPoints counts the instances of a UserID in the Lesson Table?
Or should I do all of this through php?
ex . Jeremy F (234)
The problem is : I have several different resources that can be submitted in different tables ( Lessons, Articles, Reviews, etc) This is done because the content of each resource is unique. In each resource table for a submission I will have a UserID (the person who subitted the resource)
Is there anyway I can make a new table that has columns
UserID (member)
LessonPoints (number of points from lessons)
ReviewPoints (number of points from lessons)
The php script that displays the points would add these two variables to get the number of points. However, how do I set it up so that LessonPoints counts the instances of a UserID in the Lesson Table?
Or should I do all of this through php?