PHP - average column where another column is a specific name

Question

In PHP How can I average a column where another column is a specific name. There will be several records for the same person in this table. I don't get any result here.

Eg:

 $result = mysqli_query($con,"Select * FROM record WHERE Name='Alex'");
 $avg = "SELECT Name='Alex', AVG(Q1) FROM record";
 $average = mysqli_query($avg);

 while($row = mysqli_fetch_array($average)){
 echo $row['AVG(Q1)'];
    }

Jelle Ferwerda · Accepted Answer · 2013-10-20 06:18:47Z

1

try:

 select name, avg(Q1) as Q1_Average from record where name='Alex' group by name

edited Oct 20, 2013 at 6:18

answered Oct 20, 2013 at 6:11

Jelle Ferwerda

1,2291 gold badge7 silver badges13 bronze badges

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

Comments

Nir Alfasi · Accepted Answer · 2013-10-20 06:17:01Z

0

What you need is to change your query to:

SELECT NAME, AVG(Q1) as average FROM record where NAME='Alex' group by NAME

and then when you try to read the result:

echo $row['average'];

answered Oct 20, 2013 at 6:17

Nir Alfasi

53.6k12 gold badges94 silver badges138 bronze badges

Comments

Joke_Sense10 · Accepted Answer · 2013-10-20 06:12:21Z

0

Use group by clause to find average of indivisuals:

$avg = "SELECT Name,AVG(Q1) FROM record group by Name";

answered Oct 20, 2013 at 6:12

Joke_Sense10

5,3972 gold badges20 silver badges22 bronze badges

Collectives™ on Stack Overflow

PHP - average column where another column is a specific name

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related