שאלה לגבי בנייה נכונה של סקריפט דירוגים PHP

[intercooler3819]

this is 2 different solutions to the same problem

in the first case, you aimed to creating another table
i would use that if i wanted to know who voted what and for what item

the second options is having a 'rate' field in the items and 'raters' field
then when someone adds their rate, you are increasing raters by one and raise 'rate' by his numeric value of his vote
then when you want to know the average vote you just divide the votes by the voters
this is useless when you want to know who voted what

personally, i would use the first one
just make some index's and use the right datatypes for each of the columns

good luck mate