MYSQL PHP getting average of a single field

Question

I've made a form that allows users to submit their name, a comment and a score from 1-6, which then is saved in a table in their respective fields; name, comment and score. I wan't to display the average score.

This is what I've found out so far:

$result = mysql_query("SELECT AVG(fieldName) FROM tableName");

How do I echo this out?

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

Give your result an alias, It makes accessing it easier.

Use mysql_fetch_assoc() to get your results

$result = mysql_query("SELECT AVG(fieldName) AS avg FROM tableName");
$row = mysql_fetch_assoc($result);
echo $row['avg'];

FYI, mysql_* is obsolete. Try PDO or mysqli instead.

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Nov 12, 2013 at 22:15

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2985194 Over a year ago

This worked, thanks! $result = mysqli_query($con,"SELECT AVG(fieldName) AS avg FROM tableName"); while($row = mysqli_fetch_array($result)) { echo $row['avg']; }

Collectives™ on Stack Overflow

MYSQL PHP getting average of a single field

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related