Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Date Control Problem From: Stas Trefilov (stas.t <email protected>)
Date: 01/15/01

Hello, "Ian"!
You wrote:

> Case 1:
> Now, I would like to display all data from Test table
> where my due_date is
> before the current date.

due_date LESS THAN now()

> Case 2:
> Same as case 1, I
> would like to display all data from Test table where
> expired_day plus
> posting_date is before the current date.

Try:
posting_date + expired_day < now()

-- 
Piloteers do it on the road

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>