Php Help

[DJ-Sound]

okay I am programming a new and better prodjfinder.com

I am trying to figure out how to make the company listings expire on a certian date, and be able to update the expiration time also.

I know how to have the exp. date added update, etc on a MYSQL database, but how do I make it where certain sql querys do not show up after a date.

maybe like

$query = "SELECT company_name, FROM advertisers
WHERE expiration_date > Date(m,d,y) or CURDATE()


//only show companys who exp. date is greater than the current date

will this work??

Let me know if you need more information to help..

Thanks in advance!

-Ryan

 

[Ethan]

If you use timestamps you get a numerical value for the date so you could compare them to get a range of dates, although I haven't seen it done that way and don't remember other ways to do it. But timestamps are the answer.

 

[DJ-Sound]

I got it, thanks!

 

[Ethan]

Glad that it works.