active record for [where date >= now()]

active record for [where date >= now()]

El Forum
Unregistered

08-03-2007, 06:48 AM

[eluser]smith[/eluser]
[quote author="RaZoR LeGaCy" date="1186040302"]it returned 0 entries when there are in fact 17 entries

Any other way??[/quote]

As walesmd already told you: you will always have 0 records for that query. You are looking for records that have date in the future?

I don't see how mysql can possibly return even one record with date field set in the future. Please explain which records do you want to pull from the database. If you want one hour old records you can use: date >= now()-3600 etc.

Messages In This Thread

active record for [where date >= now()] - by El Forum - 08-01-2007, 08:26 PM

active record for [where date >= now()] - by El Forum - 08-01-2007, 08:35 PM

active record for [where date >= now()] - by El Forum - 08-01-2007, 08:38 PM

active record for [where date >= now()] - by El Forum - 08-02-2007, 09:22 AM

active record for [where date >= now()] - by El Forum - 08-02-2007, 05:17 PM

active record for [where date >= now()] - by El Forum - 08-02-2007, 06:18 PM

active record for [where date >= now()] - by El Forum - 08-03-2007, 06:48 AM

active record for [where date >= now()] - by El Forum - 08-04-2007, 12:19 PM

active record for [where date >= now()] - by El Forum - 08-06-2007, 04:12 PM

active record for [where date >= now()] - by El Forum - 08-06-2007, 07:06 PM

active record for [where date >= now()] - by El Forum - 08-06-2007, 07:45 PM

active record for [where date >= now()] - by El Forum - 08-06-2007, 09:52 PM

active record for [where date >= now()] - by El Forum - 09-23-2007, 10:19 AM

active record for [where date >= now()] - by El Forum - 09-23-2007, 08:50 PM

active record for [where date >= now()] - by El Forum - 09-23-2007, 11:01 PM

active record for [where date >= now()] - by El Forum - 09-24-2007, 03:48 AM

active record for [where date >= now()] - by El Forum - 09-28-2007, 12:35 AM