Re: [PHP] Selecting all records between a date range
Jason Pruim wrote:
Hi Everyone,
I am working on a app where I need to be able to select all the values
from a database where the 'timein' field is between a certain date
range... Essentially the last 7 days...
SELECT * FROM timeStore WHERE timein>DATE_SUB(now(),INTERVAL 7 DAYS)
/Per Jessen, Zürich
.
Relevant Pages
- Re: [PHP] Selecting all records between a date range
... I am working on a app where I need to be able to select all the values ... from a database where the 'timein' field is between a certain date ... Holland, MI 49424 ...
(php.general) - Selecting all records between a date range
... I am working on a app where I need to be able to select all the values from a database where the 'timein' field is between a certain date range... ... Could not perform query: Query was empty ...
(php.general) - Re: Portable Database Choice
... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
(microsoft.public.dotnet.framework.compactframework) - Re: Portable Database Choice
... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
(microsoft.public.dotnet.framework.compactframework) - Portable Database Choice
... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
(microsoft.public.dotnet.framework.compactframework) |
|
