$consulta = mysql_query("SELECT total_a_pagar FROM compras WHERE id_usuario='".$id."'") or die (mysql_error()); while ($row = mysql_fetch_array($consulta)){ $total += $row['total_a_pagar']; } echo $total;