ציטוט:
נכתב במקור על ידי 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
|
מזאת אומרת להכין אינדקסים? ולהשתמש בסוגי נתונים, הכוונה היא לסוג השדה שמכיל את הנתנוים?