1 reply to this topic

[randyrandola]

Hello;

I have a condition that I need to move a certain amount of weight over time when I workout. Excel became too unwieldly over time and I need something a little easier.

The fields would be:

Set
Reps
Weight

Formula:

Set x Reps x Weight = Total Weight Moved

Total Weight Moved gets added to the db so I can get a report based on:

Daily
Weekly
Monthly
Yearly

This is so I can make sure I am on track to the weight being moved. A graphing function would also be nice.

I would like to build this myself as I like to do these things and I think it's simple enough. What db would be the best for this and any other advice would be welcome.

Thank you in advance for your time.

Randy

[BlaineSch]

Any database would work fine. Your rows need to be a bit more complex. You need a unique ID, and a datetime so you can search.

id, set, rep, weight, datetime

You can select like:

Quote

SELECT datetime, (`set`*`reps`*`weight`) as total FROM `mover` WHERE `datetime` BETWEEN '2009-01-31' and '2009-02-10'

That will select all of them between the two ranges. Or you can get the total of all between the range:

Quote

SELECT sum(`set`*`reps`*`weight`) AS `total` from `mover` WHERE `datetime` BETWEEN '2009-01-31' and '2009-02-10'