StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMySQL & PHP Sum of rows in foreach
primarykey
Id
11854496
data
AcceptedAnswerId
11854603
AnswerCount
4
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2012-08-07T21:36:47.757
FavoriteCount
0
LastActivityDate
2012-08-07T22:12:58.270
LastEditDate
2012-08-07T22:12:58.270
LastEditorUserId
1218333
OwnerUserId
1218333
ParentId
0
PostTypeId
1
Score
2
ViewCount
2383
LastEditorDisplayName
text
Body
Im trying to get the sum of workouts in a row and then order all rows by the sums to get what place the team is in and so there listed in the correct order. Im getting a little lost in my own logic right now trying to figure this out. I understand the MYSQL sum function but cant seem to see how i could use it to help me in this instance. So something like this: <img src="https://i.stack.imgur.com/TjBlc.png" alt="Example"> Here is my current Table schema: <pre><code>CREATE TABLE workouts ( team_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, username VarChar(255) NOT NULL, team_name VarChar(50) NOT NULL, week1 INT NOT NULL, week2 INT NOT NULL, week3 INT NOT NULL, week4 INT NOT NULL, week5 INT NOT NULL, week6 INT NOT NULL, week7 INT NOT NULL, week8 INT NOT NULL, week9 INT NOT NULL, week10 INT NOT NULL, week11 INT NOT NULL, week12 INT NOT NULL ) engine=innodb; </code></pre> And Here is my display so far: <pre><code><?php $count = 0; $statement = $db->query('SELECT * FROM workouts'); foreach($statement as $row): ?> <tr> <td><?php $count++; ?></td> <td><?php $row['team_name']; ?></td> <td><?php $row['week1']; ?></td> <td><?php $row['week2']; ?></td> <td><?php $row['week3']; ?></td> <td><?php $row['week4']; ?></td> <td><?php $row['week5']; ?></td> <td><?php $row['week6']; ?></td> <td><?php $row['week7']; ?></td> <td><?php $row['week8']; ?></td> <td><?php $row['week9']; ?></td> <td><?php $row['week10']; ?></td> <td><?php $row['week11']; ?></td> <td><?php $row['week12']; ?></td> <td><?php ?></td> </tr> <?php endforeach; ?> </code></pre>
Tags
<php><mysql>
Title
MySQL & PHP Sum of rows in foreach
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJohn Ayers
UserOwnerUserId
1. USJohn Ayers
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POMySQL & PHP Sum of rows in foreach
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POMySQL & PHP Sum of rows in foreach
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.