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:

Code : SELECT * FROM metal_posts WHERE Date>='$last_visit'

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

Hi,

Try to use date_format function of MySQL in your query, what you have to do is apply this function to both the dates being compared so that MySQL can apply the matching filter and show you the records.

Also make sure that last_visit is also a complete time stamp i.e. date and time and not just time.

Hope this helps.

Cheers,

Maneet

__________________
Maneet Puri
Web Design Company / Data Processing Services