Re: Selecting all records between a date range

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <japruim@xxxxxxxxxx> wrote:

>
>        SQLTEST: SELECT * FROM `timeStore` WHERE        `timein` BETWEEN
> 1222315200 AND 1222920000
> Could not perform query: Query was empty
>
> <japruim@xxxxxxxxxx>


Put a ' around your timestamp numbers.  I think that should fix that query.
Although I'll admitt, I have no way to test that on mysql, but that is how
MS SQL works...

-- 
-Dan Joseph

www.canishosting.com - Plans start @ $1.99/month.

"Build a man a fire, and he will be warm for the rest of the day.
Light a man on fire, and will be warm for the rest of his life."

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux