I believe PHP and MySQL use two different definitions of the start of a time stamp. One uses 1974 the other 1900 (I don't know exactly). If you echo strtotime($attributes[startdate]) , UNIX_TIMESTAMP (datestamp)
Also, in your query you are looking for all headlines that have strtotime($attributes[startdate]) == UNIX_TIMESTAMP (datestamp). you have two strtotime($attributes[startdate]) but not an 'end date ' "Charles Kline" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
