Counting how many times a rating was entered in a MySQL Database using PHP

MX1CAN

New Member
I'm trying to count how many times an article has been rated by my members buy using PHP to count a certain articles total entered ratings that have been stored in my MySQL database. I really want to use PHP and not MySQL to do this and was wondering how I can do this?I hope I explained this right?An example would be very helpful my MySQL database that holds the ratings are listed below.Here is the MySQL database.\[code\]CREATE TABLE articles_ratings (id INT UNSIGNED NOT NULL AUTO_INCREMENT,ratings_id INT UNSIGNED NOT NULL,users_articles_id INT UNSIGNED NOT NULL,user_id INT UNSIGNED NOT NULL,date_created DATETIME NOT NULL,PRIMARY KEY (id));CREATE TABLE ratings (id INT UNSIGNED NOT NULL AUTO_INCREMENT,points FLOAT UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY (id));\[/code\]
 
Back
Top