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 doesnt seem to work.
first off i added a colume 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:
SELECT * FROM metal_posts WHERE Date>='$last_visit'
now doing it that displayed 0 results everytime 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 isnt the problem here.