date range assistance needed
| From: | charles kline | Date: | Mon, 03 Mar 2003 23:21:31 +0000 |
| Subject: | date range assistance needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137986@lists.php.net to get a copy of this message | ||
Here is my current query:
$qAnnouncement =
'SELECT id,headline
FROM tbl_funding
WHERE 1
AND ((UNIX_TIMESTAMP (datestamp) >= ' . strtotime($attributes[startdate]) . ') AND (UNIX_TIMESTAMP (datestamp) <= ' . strtotime($attributes[startdate]) . ')) LIMIT 0, 30';
Where datestamp is set in MySQL with a timestamp(14) and $attributes[startdate] and $attributes[enddate] are in the format mm/dd/yyyy
My query does not return any results. I know there must be something wrong, can anyone point it out?
Thanks,
Charles