| | |
Date functions
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
This is an SQL question, which belongs in the database section.
If you want to find all the records that have dates in sort_date that are after the current date, use the following query: Notice that you want the sort_date to be greater than NOW(), not less than.
If you want to find all the records that have dates in sort_date that are after the current date, use the following query:
PHP Syntax (Toggle Plain Text)
SELECT * FROM events WHERE sort_date>NOW()
Did we help you? Did we miss the point entirely? Update your thread and let us know.
Don't like the answers you are getting?
Did you try searching?
Clean up and optimize Windows 2000/XP
Don't like the answers you are getting?
Did you try searching?
Clean up and optimize Windows 2000/XP
![]() |
Similar Threads
- 'Object variable or With block variable not set' Error (ASP.NET)
- Where can I get a Library of std ASP functions (ASP)
- Julian Date functions (VB.NET)
- Microsoft Access date validation Need a solution (Database Design)
- C++ getline question (C++)
- create a weekly and monthly report (ASP)
- Zend PHP Certification (PHP)
Other Threads in the PHP Forum
- Previous Thread: folder searching
- Next Thread: Starting project
| Thread Tools | Search this Thread |
action ajax apache api array auto beginner binary bounce broken cakephp checkbox class cms code cron curl database date display domain dynamic echo email error errorlog file files folder form format forms function functions google href htaccess html image include insert integration interactive ip java javascript joomla limit link load login loop mail malfunctioning masterthesis menu mlm multiple mysql nodes oop paypal pdf php popup problem query radio ram random recursion reference regex remote return script search server sessions sms soap source space sql syntax system table tutorial unset update upload url validation validator variable video web websitecontactform xml youtube





