"MikeBlezien" <[EMAIL PROTECTED]> wrote:
> ROUND((tally / votes),2) AS Rating
>
> which I believe should give me 4...correct?? or would it better to do the
> calculations within the script after extracting the column data ??
I think that you'll find that it is faster to do the calculation within
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a ra
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a ra
