[Tomer Pearl]

נכתב במקור על ידי nitsanbn

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

תודה על התגובה...
לא הבנתי את המשפט האחרון

just make some index's and use the right datatypes for each of the columns

מזאת אומרת להכין אינדקסים? ולהשתמש בסוגי נתונים, הכוונה היא לסוג השדה שמכיל את הנתנוים?