AVG ...how can I have more then 1 field?

[nec9716]

ok here what is my issue:

 

$litres= 'SELECT avg (litre) FROM gb1 ';

 

I want to be able to have more avg from gb1?

 

thank you and have a great day

[beboo002]

$litres= 'SELECT avg (litre) as liters,avg(xyz) as xyz1 FROM gb1 ';

 

echo $row[liters];

echo $row[xyz1];

 

If this is not ur requirement please describe ur question what you need?

[nec9716]

ok I get that working

 

 

now if I want to have avg and total in the same command how can I set that or do I have to make 2 separate request?

 

 

presently I have something like that:

 

$sqlt = 'SELECT avg (litre) as liters , (mpg) as mpg FROM gb1 ';

[wildteen88]

You can use SUM(liters , mpg) as total maybe