Re: database design question
| From: | olinux | Date: | Mon, 29 Sep 2003 08:21:16 +0000 |
| Subject: | Re: database design question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30749@lists.php.net to get a copy of this message | ||
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