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


-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to