need help with PHP/MySQL

oks, this code works for what i was looking for : $mysql = mysql_connect("host", "user", "pass"); mysql_select_db(teste); $sqlquery = "SELECT * FROM preco"; if ($resultset = mysql_query($sqlquery, $mysql)) { echo "<TABLE>"; while ($row = mysql_fetch_array($resultset)) { /* Remove R$ from Preco field */ $fullprice = ($row[preco]); $price = substr ("$fullprice", 3); $totalprice += ($price); } echo "<TR><TD>Total:</TD>"."<TD>".sprintf('%0.2f', $totalprice)."</TD>"."</TABLE>"; } but this code just calculate the sum fom one row .. how can i calculate the all rows from a table ... thanks GS