[Resolved] how to calculate the total of several table fields

[helz]

in a table i have ratings fields:
rat_0 to rat_5 now each of these values gets incremented
every time someone votes. how do i calculate the total number of all the fields?

eg:
rat_0 = 3
rat_1 = 1
rat_2 = 4
rat_3 = 8
rat_4 = 3
rat_5 = 2

so the total would be: 21

[LordShryku]

SELECT sum(rat_0 + rat_1 + rat_2 + rat_3 + rat_4 + rat_5)
FROM table

[helz]

ah ty
i did count() and got an error 😃

thank you my lord

[helz]

if i have that in mysql_query()

how do i get it into number form?
mysql_result() ?

[LordShryku]

or mysql_fetch_row or mysql_fetch_array.

Using mysql_fetch_row, you can do

$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$yourNumber = $row[0];

If you use mysql_fetch_array, you'll need to give the calculation an alias, like

$sql = "SELECT sum(rat_0 + rat_1 + rat_2 + rat_3 + rat_4 + rat_5) AS total
        FROM table";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result)) {
   $yourNumber = $row['total'];
}

[helz]

ahh, so the AS thing can let you give a group a name, nicely done lord

[LordShryku]

🙂