This is an example of a simple consumer ranking system that allows a user to specify a Category and an Item within that category to rate. For example, if the category is "restaurant", the user can rate a particular "restaurant" within that category. This is a generic ranking system that lacks a polished look and feel, however, most of the features necessary for a ranking system are available.
Although this is a useful application, it is primarily a mySQL database example. The material for this web page came from the AT THE FORGE written by Reuven M. Lerner. The article Consumer Rankings appeared in the February 2000 issue of the Linux Journal on page 34. Three database tables are shown below:
| RankCategories Table |
RankItems Table |
Rankings Table |
|---|---|---|
| category_id | item_id | ranking_id |
| category_name | category_id | item_id |
| category_description | item_name | ranker_name |
| - | item_description | |
| - | - | entry_datetime |
| - | - | comments |
| - | - | rank |