courtjester

Ok, here's the thing, I Am creating a rating system for a site, where you can pick a band, listen to some samples, read their bio, and then rate them on a scale of 1-5 . 1 being sucky and 5 being good . . Well to do this, would I need to just set the code to add each row together then divide by total # of rows? Would that work to get me an average? Or is there a better/easier way of doing this? Just trying to save me a little time.

Smokie

Well if you want to save time, just go to APSIN.com and search for a rating system which someone else has already written!

spinal007

smokie's option is fine, but if you want to make it yourself design a table that will store all the scores as different records:
eg.
band - score
'linkin park' - 5
and so on...

then use the AVG SQL statement to retrieve the average score
something like: SELECT AVG(score) AS average_score FROM Feedback_Table WHERE band='band name'