Table structure of my-favorites table?

Discussion in 'MySQL' started by 123GoToAndPlay, Jan 13, 2010.

  1. #1
    and a my-5-latest-viewed table.

    would this be sufficient:
    
    tbl_favs
    -------------
    id user_id user_favorites
    
    Code (markup):
    user_favorites as an array (serialize) of advert_ids

    for the 5 latest viewed adverts i

    
    tbl_latest_viewed
    --------------
    id session_id latest_viewed_adverts
    
    Code (markup):
    latest_viewed_adverts as an array (serialize) of advert_ids

    Only thing is i don't know how to get the latest viewed? Based on a cookie/session and when an user visits an advert add to tbl_latest_viewed. But how to handle fifo (first in first out)??
     
    Last edited: Jan 13, 2010
    123GoToAndPlay, Jan 13, 2010 IP