Wednesday, July 22, 2009

Favorite: page or not page?

I'm not very certain if I should make a Favorite page, or just insert favorite as a function in the users page. Let's take a look at what function I need for favorite:
  1. Add a game to favorite - from any page
  2. Delete a game from favorite <- from favorite view mode
  3. View favorites of a user <- possibly from user page & favorite page
To view the favorite, I need to retrieve a list of mids with same userid:
SELECT mid FROM favorites WHERE userid = 'userid';
Then, with the list of mids, I can retrieve title, author, category from metadata:
SELECT title, author, category FROM metadata WHERE mid = 'mid';
then, print the result.

No comments:

Powered By Blogger