creating a post made since last visit problem
Posted: Mon Feb 09, 2009 2:36 pm
hi,
on a news program i made i want to allow my members to see what new articles were made since they last visited the site. pretty much what i want to do is exactly how phpbb and other bbs programs do.
now looking at them i applied the same method but it doesn't seem to work.
first off i added a column last_visit which would have the last time they visited the site(in time())
then i made it do a search with the following query:.
now doing it that displayed 0 results every time no matter what. changed >= to <= just displayed all of the news articles.
so question is, what am i doing wrong?
to let you know all the dates on my program are in time() format so format issue isn't the problem here.
thanks
on a news program i made i want to allow my members to see what new articles were made since they last visited the site. pretty much what i want to do is exactly how phpbb and other bbs programs do.
now looking at them i applied the same method but it doesn't seem to work.
first off i added a column last_visit which would have the last time they visited the site(in time())
then i made it do a search with the following query:.
Code: Select all
SELECT * FROM metal_posts WHERE Date>='$last_visit'so question is, what am i doing wrong?
to let you know all the dates on my program are in time() format so format issue isn't the problem here.
thanks