VERY small problem, help please...quick :(

[3raser]

Have to go soon...

 

require("settings.php");

//extract
$extract = mysql_query("SELECT * FROM users");
$numrows = mysql_num_rows($extract);

while ($row = mysql_fetch_assoc($extract))

{
$total = 0;
$overall = $row[frpcash] + $total;

echo "Total FrP cash: ". $overall ."";
           
} 

 

Result: "Total FrP cash: 10Total FrP cash: 10"

 

But it should say 20, AND the text is messed up :/

[sasa]

try

require("settings.php");
$extract = mysql_query("SELECT * FROM users");
$owerall = 0;
while ($row = mysql_fetch_assoc($extract)) $overall += $row['frpcash'];
echo "Total FrP cash: ". $overall ."";

[trq]

Or better still.

 

require("settings.php");

if ($result = mysql_query("SELECT SUM(frpcash) FROM users")) {
  echo "Total FrP cash: " . mysql_result($result, 0);
}