How to indicate Post not yet been viewed

[kcgame]

Hi all,

Have been thinking about whether if there's other easy alternatives to this problem..

Right now, i have standard columns in my db table which consists of parent_id, child_id, topic, date_created and so on for my simple forum.

How can i know the user has already viewed a topic?
I'm currently making use of sessions for log in. Is it practical to add an extra column to indicate that the user has viewed this post or not?
Any help / comment is appreciated. Thanks.

[devinemke]

Originally posted by kcgame
Is it practical to add an extra column to indicate that the user has viewed this post or not?

that will not work since you want to track whether each indvidual user has viewed the topic. you would need a separate table that links the users table to the topics table using the primary key field from each table.

[kcgame]

Originally posted by devinemke
that will not work since you want to track whether each indvidual user has viewed the topic. you would need a separate table that links the users table to the topics table using the primary key field from each table.

hmm..you're right, devinemke. Check by log in time?
Not sure if this is a PHP or database problem:queasy: