Getting lowest number and add total?!?!

[jmansa]

I'm trying to figure out how to get the lowest record for a specific user for each column and in the same query get a total of those numbers...

The first part I have figured out, but adding the total I can't seem to work...

Here is what I have done:

$sql = "SELECT (@st1:=COALESCE(MIN(stroke1),0)) AS st1,
								(@st2:=COALESCE(MIN(stroke2),0)) AS st2,
								(@st3:=COALESCE(MIN(stroke3),0)) AS st3,
								(@st1+@st2+@st3) AS st_total
								FROM ".$prefix."_stroke WHERE user = $user 
								GROUP BY user";

st1, st2, st3 comes out as they should, but the st_total comes out with nothing... Please help!

[jmansa]

I have come so far to figure out it is the "MIN(stroke)" which is the problem... If I just insert stroke without the MIN it works perfectly... How do I get The MIN into this query???

[Lars_Berg]

select st1,
       st2,
       st3,
       st1 + st2 + st3 as st_total
  from (select coalesce(min(stroke1),0) AS st1,
               coalesce(min(stroke2),0) AS st2,
               coalesce(min(stroke3),0) AS st3
          from " . $prefix . "_stroke 
         where user = $user) dt