While Loop Variable

[rascle]

Hi

i am have a load of numbers in a database and want to add them all together, so i have created a simple while loop that should add them all together, however i am not getting any results. Here is the code:

<?php

$totalgamespace = 0;
$rhysgamespace = mysql_query("SELECT * FROM 'games'");
while($gamespace = mysql_fetch_array($rhysgamespace)){
$rgamespace = $gamespace['size'];
$totalgamespace = $rgamespace + $totalgamespace;
}
echo $totalgamespace;


?>

 

Please help, thanks

Rhys

[PFMaBiSmAd]

Your query is failing because the table name is enclosed in single-quotes, making it a string rather than a table name.

 

Once you fix that error, you do know that you can use the mysql SUM() function directly in your query to do this. No slow loop using parsed, tokenized, interpreted php code is needed.

[rascle]

You mean:

$rhysgamespace = mysql_query("SELECT * FROM \"games\"");

?? cause i tried that but it didnt work

and i will have a look for the SUM function, Thanks

[simonrs]

No I believe he means:

 

SELECT  SUM(`column`) FROM `tablename`

 

I believe that's correct. Note the use of: `, and not '.

[rascle]

Thanks

I changed it to:

$rhysgamespace = mysql_query("SELECT SUM(`size`) FROM `games`");

$gamespace = mysql_fetch_array($rhysgamespace);

 

echo $gamespace;

 

But it now says ARRAY when echoed.

[simonrs]

Have a look by doing print_r($gamespace); - see if you can work out for yourself how to get the sum out

[rascle]

I used an alias and managed to get it to work:

$spacegame = "SELECT SUM(size) AS gamesize FROM `games`";

$gamespace = mysql_query($spacegame);

$gamespace = mysql_fetch_array($gamespace);

echo $gamespace['gamesize'];