With the ratings being stored in their own table it shouldn't be too hard to select the ones from a particular image and print out the information.
I'm lost on this. My first try is in this thread
. It's a join on posts and ratings. Leaves out the guys who rated but did not comment.
I wonder, what is best for me to do here?
1. Can this query be salvaged? Should I get the ratings from guys that don't have a post entry, and phoney up the rest of the postbit data... Not sure how those queries would work together...?
2. Should I remove the rating link and force guys to rate via comments (also removing the minimum comment requirement)? There goes your table optomization!!
3. Should I throw away the rating table and stash the rating in the comment, also forcing comment entry...?
To reiterate. Most members rate, but do not comment. We want to see who rated, and what they rated, whether they commented or not. EG
Fred 4 start "I liked this"
Joe 1 star
Pete 1 star
Helga 5 star "This is my comment"
...we see Joe and Pete gave it low ratings and no comments.
Just looking for some guidance here. Which solution, do you suppose, will hurt me less in the long run. Or am I missing something else?
* * *
"Changing votes is not allowed" ?? You mean "Sorry, we have not yet gone to the hassle of coding this"
Because change their mind is what people do. Not to mention making mistakes. I'd like to be able to change my vote any time. RC876 perhaps...
Hope this makes sense. Many thanks in advance for a considered reply.
Keep the faith.