StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Here is my solution.</p> <p>Instead of just echoing the database values as your process them, I dump them into an associative array with the total number of workouts as a key. Then you can sort them using ksort. Once that is done you can print out the array using a foreach loop.</p> <p>I didn't type out the full array function but it should give you an idea.</p> <pre><code><?php $count = 0; $statement = $db->query('SELECT * FROM workouts'); $workouts = array(); while ($row = mysql_fetch_array($statement)) { $total = 0; for($i = 0;$i < 13; $i++) $total = $total + $row['week'.$i]; //Build the array containing each teams workouts $workouts[$total] = array('team_name' => $row['team_name'],'week1' => $row['week1']); } ksort($workouts); $rowcount = 0; foreach ($workouts as $total => $team): ?> <tr> <td><?php echo $rowcount++; ?></td> <td><?php echo $team['team_name']; ?></td> <td><?php echo $team['week1']; ?></td> <td><?php echo $team['week2']; ?></td> <td><?php echo $team['week3']; ?></td> <td><?php echo $team['week4']; ?></td> <td><?php echo $team['week5']; ?></td> <td><?php echo $team['week6']; ?></td> <td><?php echo $team['week7']; ?></td> <td><?php echo $team['week8']; ?></td> <td><?php echo $team['week9']; ?></td> <td><?php echo $team['week10']; ?></td> <td><?php echo $team['week11']; ?></td> <td><?php echo $team['week12']; ?></td> <td><?php echo $total ?></td> </tr> <?php endforeach ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload