i would add a second table and also store the totals
in the lyrics table like you suggested

then you can do things like top 10 this week / top 10
this month and make sure its not being abused 

LYRICS_RATINGS - id | lyric_id | rating | vote_date |
remote_addr

same idea for hits/impressions

olinux


--- John Ryan <celticfc@[...].ie>  wrote:
>  ive a table called 'lyrics' which is the main
>  content on my site, song
>  lyrics. im thinking of introducing rate this lyric
>  and all that kind of
>  stuff into the site. would it be better, from a
>  design point of view, to
>  create a second table for lyrics ratings and hits or
>  just add a 'ratings'
>  and 'hits' field names to the exisitng table??
>  
>  -- 
>  PHP Database Mailing List (http://www.php.net/)
>  To unsubscribe, visit: http://www.php.net/unsub.php
>  


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php