Link to home
Start Free TrialLog in
Avatar of oo7ml
oo7ml

asked on

Calling & Storing PHP Values

Hi, i am working on a site that allows members to make a small donations to a user's (friend) marathon profile page… i have a 'marathon_profile' table in my database and i have a 'donations' table in my database.

MARATHON_PROFILE
- id
- user_id
- total_amount
+ 10 more columns

DONATIONS
- id
- user_id
- marathon_id
- amount
+ 5 more columns

I need to display the total amount raised on the marathon profile and i am trying to decide on how i should store / record the total amount raised and how i should query the total amount in order to display it:

01 - which table should i store the total amount of money received in
A - simply add / increment the $total_amount field in the 'marathon_profile' by the individual donation amount AND record each individual donation $amount in the 'donations' table
B - JUST record the individual amount in the 'donations' table and forget the idea of having a $total_amount and incrementing it each time

02 - how should i call for the total amount so that i can display it on the marathon profile page
A - just call for the $total_amount in the 'marathon_profile' table (this seems a lot less workload on the site)
B - run a query which will add up add the $amounts WHERE marathon_id = the marathon page (this seems a lot more work load on the site)

Thanks in advance for your help
ASKER CERTIFIED SOLUTION
Avatar of Gary
Gary
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oo7ml
oo7ml

ASKER

Ok, thanks all... just thought that that approach would slow the site down as it would need to run that query each time a user visits the marathon page
Well everytime they visit the page you still have to run a query to get the details so makes no difference.
Avatar of oo7ml

ASKER

Good point... thanks for the advice guys...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial