if ($r = sql_select( array( 'a.column AS colA', 'b.column AS colB', 'SUM(b.number) AS btotal' ), array( 'tableA AS a', 'tableB AS b' ))) { while ($ligne = sql_fetch($r)) { // we now have access to: // $ligne['colA'] $ligne['colB'] $ligne['btotal'] } }