stanneo
Joined: 03 Feb 2011
Posts: 14
Posted: 2011-03-30 20:45
Back to top
Reply with quote
|
Hi everybody,
after ID is my second column a date column in format
2011-03-30 16:00:00
How can I filter records from the database which are within a data range, for example beetween:
2011-03-25 16:00:00 and 2011-03-30 16:00:00
The Code for the date field is :
$opts['fdd']['Datum'] = array(
'name' => 'Datum',
'select' => 'T',
'options' => 'LVRC', // updated automatically (MySQL feature)
'maxlen' => 19,
'default' => 'CURRENT_TIMESTAMP',
'sort' => true
);
I mean, the user of the table must be able to filter these records
Thank you for any suggestions
stanneo
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2011-04-06 15:08
Back to top
Reply with quote
|
'select' => 'N' provides some filtering for one point but not for a range.
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
