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
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
