I have a table of people and another table of ratings.<BR><BR>I would like to have a computed field in the people table that contains the average rating, but since mysql doesn't support this yet ...

A MySQL database is made up of one or more tables. These tables contain rows and columns, which in turn contain data. The columns hold the headers of the table that identify the data in the rows ...

The MySQL SUM function takes the fields or rows you input and adds their values together, then returns the total. Save your query in a PHP variable. You can use the function as many times as you ...