I think i need help on theory... I need to create script tha will hanle voting for the photos.
Here is what I have table w/ usernames and assosoated photos and table with photos and the vote ratings.
Now its easy to do something like we open user profile and see the ratings for the photos they have (select all photos for username and yhen get total rating for the photos returned.
But what if I wnat to show overall ratings for photo not relating to the user name and if I want to show like top 10 how would i do that?
Thankx!
PS: I though to calculate ecerything but if i will select all hotos it will take lots of time to render