Hi,
Using PHP? If so, this works quite nicely if you pass your dates as unix
timestamps:
SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND
FROM_UNIXTIME($theMinTime) < col)
In other words, "col" needs to be between $theMinTime and $theMaxTime as
in $theMinTime < col < $theMa
WHERE col BETWEEN $from_date AND $to_date ???
-Original Message-
From: Claire Forchheimer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 5:35 PM
To: [EMAIL PROTECTED]
Subject: Extracting fields from a table
I want to select all entries in my table that in a column with g
Hi,
Using PHP? If so, this works quite nicely if you pass your dates as unix
timestamps:
SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND
FROM_UNIXTIME($theMinTime) < col)
In other words, "col" needs to be between $theMinTime and $theMaxTime as
in $theMinTime < col < $theMa
On Wednesday 06 February 2002 3:35 pm, Claire Forchheimer wrote:
> I want to select all entries in my table that in a column with given
> dates findes all dates inbetween $from_date - $to_date. (These are
> vars that the user supplies from the HTML-page). I don't know how to set
> up the SELECT
