Re: [PHP] Selecting all records between a date range

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."

Relevant Pages

  • Re: Queries and Parameters
    ... that I have to visit (testing of fire systems) at various times of the year. ... This way I have been using a basic query and calling up my report each ... Is doing a fire inspection challenging? ...
    (comp.databases.ms-access)
  • Re: How to secure SQL website
    ... That depends on the way you fire up your query to the server and the ... Are ou building up Select query via some dynamic sql or do you use stored ... what method and what provider are you using? ...
    (microsoft.public.sqlserver.security)
  • Re: Virtual segment usage - now Im confused.....
    ... We managed to fire off an onstat -a and having used onstat -g mem to ... The query is reproduced below. ... We've got the SQL statement cache off at present, ...
    (comp.databases.informix)
  • Re: queries in access....urgent please
    ... Microsoft Office/Access MVP ... about 5000 records ie Table B, both the tables have many common fields, I ... Is is possible to fire such query using MS Access? ...
    (microsoft.public.access.queries)
  • Re: Getting first and last entities in collection in EJB3
    ... I have a one-to-many bidirectional relation between two entities A and ... of a way to do this in a single query. ... I fire two queries each to get the first and last entities B in the B ...
    (comp.lang.java.programmer)