Incorporating a Rating System to individual Records in an Existing Database

[recset]

PROB: Incorporating a Rating System to individual Records in an Existing Database

My site, www.recondemand.recset.com is in development and I want to give each record in an existing database that I have created, a rating record (Rating System, i.e. Star System).
So my question is, how do I append/link a Star Rating System Database to my existing Database, so that each record of my database can have their own unique rating system?

More Detail:
main.php
profile.php
player.php

main.php will list several records > once a record is clicked, it will go to the profile.php page to display information (Video title, name, etc.) > Then when the viewer clicks player.php, the video will play on that page ( I would like the rating system to be incorporated on this page somehow, but uniquely linked with the record it received from main.php & profile.php.

---

Hope this helps in your analysis to my problem.

Thank you,
I am an Intermediate PHP Programmer btw

[matchew]

you'd need a field to hold the rating, and a field for the number of time is was rated, for the record.
then when the record if rated just increase the field that holds the rating and rated.

[recset]

Ok, thanks for your help, do you know of how exactly I would do that? Do you perhaps have an example or know of a Dreamweaver extension that accomplishes such tasks?

Thanks