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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to