ROUND(AVG(scores))

[Bickey]

HOw to get the AVERAGE of my entire database?

 

$query = "SELECT ROUND(AVG(scores)) FROM table";

 

Thanks!

Bickey 

[nafetski]

With any of the mysql aggregate functions (SUM, AVG, etc) you'll need to have a GROUP BY clause

[Bickey]

Hi nafetski.

 

I'm uncertain , what if I want to get the average and there's nothing to be GROUP BY. (I don't have similar values in any of the rows).

 

Thanks.

Bickey 

[BlueSkyIS]

You do not need a group by clause for that SQL. it should work as written. have you tried it?

[Bickey]

yes, I did try it. The result I got was "Resource id #2"

 

Bickey 

[BlueSkyIS]

that's a problem with your PHP. can you post your code?

[Bickey]

The code is infact too long.

 

but is this where I'm doing wrong. TO display the result (used in an email)

 

<br>"The average score is ".$query."<br>

 

Bickey 

[BlueSkyIS]

can we at least see the part of the code where $query is executed and the value of $query is set??

[Bickey]

These are the only two lines which is used to get the AVG and display (in an email).

 

$query = "SELECT ROUND(AVG(scores)) FROM table";

 

//email

<br>"The average score is ".$query."<br>

 

Bickey 

[BlueSkyIS]

apparently you never execute the SQL in $query. But I can't be sure as there isn't enough code to tell.

[Rifts]

$query = "SELECT ROUND(AVG(scores)) FROM table";

 

change to

 

 

$query = mysql_query("SELECT ROUND(AVG(scores)) FROM table");

[Bickey]

That did not work.

 

Bickey 

[Pikachu2000]

Of course it didn't; the query is never executed.

 

$query = "SELECT ROUND(AVG(scores)) AS avg FROM table";
$result = mysql_query($query);
$array = mysql_fetch_assoc($result);

echo "<br>The average score is {$array['avg']}<br>";