select sum dentro de un while

[GatorV]

Mmm prueba este query:

Código sql:

SELECT oper_prin, SUM(mts_prin) AS 'suma' FROM `principal` GROUP BY oper_prin
 

Luego en tu PHP:

Código php:

<table width="200" border="1">
  <tr>
    <td>operador</td>
    <td>tot. mts. </td>
  </tr>
  <tr>
    <td>
<?php
   include("conn.php");
   $link=Conectarse();
   $q1=mysql_query("SELECT oper_prin, SUM(mts_prin) AS 'suma' FROM `principal` GROUP BY oper_prin");
   while($row = mysql_fetch_array($q1)) {
echo " <tr><td>".$row["oper_prin"]."</td>" ;
        echo "<td>".$row["suma"]."</td></tr>" ;
   }
   mysql_free_result($q1);
?></td>
  </tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
 

Saludos