Rollup

[Marmot]

 SELECT SUM(a*b) as total FROM tab_1 GROUP BY a WITH ROLLUP

I've run this simple query in the terminal and it's ok

Does anyone know how to echo out the last row generated by the modifier GROUP BY....WITH ROLLUP ?

Like I just want the total and not the figures which make it up.

(There may be disagreement but I think this query is OK in the Mysql forum.)

Marmot

[swampBoogie]

Just remove the group by clause

SELECT SUM(a*b) as total FROM tab_1

[Marmot]

that does it! thank you!

 <?php
$dbcnx=mysql_connect ( 'localhost','root','blah' );
mysql_select_db ( sumtext,$dbcnx );
$sql ="SELECT SUM(a*b) as total FROM tab_1";
$result = mysql_query ($sql);
$row = mysql_fetch_array ( $result );



echo ($row ['total'] ."<p>");

  
?>