attempting to add a column
Alright, I have no idea what I'm doing with this so I'll apologise now if I don't make everything clear.
I'm keeping track of the money I make over the summer. I have a database named "work" with a table named "money." In that table I have a column named "total" where I have the total amount I earned that day.
I would like to display the sum of that column. I just have this on my computer so it doesn't matter if it's ugly coding or anything as long as it works.
I'll be happy to provide you with any additional information you might need to help me out. I'm using Xampp and MySQL 5.0.21, made everything in the PHPMyAdmin they have in there.
waffles Radio Coming to a set of speakers near you September 2006
Greg K posted this at 05:59 — 4th July 2006.
He has: 2,145 posts
Joined: Nov 2003
issue something like
SELECT SUM(total) FROM money
-Greg
waffles posted this at 07:09 — 4th July 2006.
They have: 54 posts
Joined: Jun 2006
Where do I put that? Does it need to go inside of everything? I've learned by editing, so my knowledge is kind of all over the place.
Mark Hensler posted this at 04:45 — 5th July 2006.
He has: 4,048 posts
Joined: Aug 2000
Just run that query when you want to see the total.
Have you considered using an Excel worksheet.
waffles posted this at 06:49 — 5th July 2006.
They have: 54 posts
Joined: Jun 2006
Yeah, mostly I just wanted to do it this way. It's obviously not turning out the way I wanted it to though.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.