Simple php/mysql maths

Wimnat · 17 Oct 2006 at 15:59

I am so hungover so it's probably not the best time to be trying to remember php so if you guys can help me out here i would be very grateful!

I have a table with a number of entries for scores. I want to add these up and display a total with a view to eventually sorting each entry in to who had the highest score.

MySQLTable
Name Score1 Score2 Score3
A 1 2 4
B 3 5 1

So i want to query the table, add up score1, 2 and 3 and display the total.

Help please!

robmiller · 17 Oct 2006 at 18:16

Code:

$result = mysql_query("
SELECT
( score1 + score2 + score3 ) AS total, name
FROM scores
");

while ( $row = mysql_fetch_assoc($result) ) {
    echo "Name: {$row['name']}. Score: {$row['total']}.<br />";
}

Wimnat · 17 Oct 2006 at 19:10

I have lots of other fields i want to select other than just name. Is there a quick way to select all or do i have to write out the name of every field?

robmiller · 17 Oct 2006 at 19:14

Code:

SELECT
scores.*, ( score1 + score2 + score3 ) AS total
FROM scores