[thelist] strange php/mysql display problem

[Fred Jones]

> I am using a javascript program called flot to build charts and php/mysql to
> feed data.  Almost everything works but when I run a very very simple mather
> operation the chart fails.
> $query = "select count(rating) as num_ratings, sum(rating) as sum_ratings
> from some_table " ;
> $result = mysql_quer
>  # $avg_rating = $sum_ratings / $num_ratings;  // this causes failure in the
> display

Why not use:

$query = "select count(rating) as num_ratings, sum(rating) as
sum_ratings, as count(rating)/sum(rating) as avg_rating from
some_table " ;

:)