Posted by guitarromantic on 05/11/06 15:59

Rik wrote:

> An extra table would help to make the data more accessable.
>
> TABLE reviews
> review_id
> some_other_fields
>
> TABLE staff
> staff_id
> some_other_fields
>
> TABLE staff_reviews
> review_id
> staff_id

Just to clarify - so when I display a review, would I have to then
search staff_reviews for $foo (review id) and then select all the
associated staff_ids to then display my links and stuff?

I think this is a better method also because as well as each review
having multiple authors, it has multiple scores too (currently we just
write the individual scores in the body of the review and store the
average score in the db - with this system I can store a score for each
review in staff_reviews and then just use php to display the average,
right?

[Back to original message]