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@iol.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
