Re: Selecting all records between a date range
| From: | Dan Joseph | Date: | Thu, 02 Oct 2008 17:31:19 +0000 |
| Subject: | Re: Selecting all records between a date range | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-281401@lists.php.net to get a copy of this message | ||
On Thu, Oct 2, 2008 at 12:35 PM, Jason Pruim <japruim@raoset.com> wrote:
>
> SQLTEST: SELECT * FROM
timeStore WHERE
> timein BETWEEN
> 1222315200 AND 1222920000
> Could not perform query: Query was empty
>
> <japruim@raoset.com>
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."