Query by date range

[dk4210]

Hello Guys,

 

I have a question.. I am trying to query the data base for a specific date range but it's not displaying the correct date range..

 

Here is my query

SELECT * FROM report WHERE start_date AND end_date BETWEEN '2011-08-01 00:00:00' AND '2011-08-31 00:00:00'

 

It seems to be loading all the rows not just the date rage specified above.. Please advise..

 

Thanks, Dan

[ManiacDan]

SELECT * FROM report WHERE (start_date BETWEEN '2011-08-01 00:00:00' AND '2011-08-31 00:00:00') AND (end_date BETWEEN '2011-08-01 00:00:00' AND '2011-08-31 00:00:00')

-Dan

[dk4210]

On more question for ya..

Is there a way to construct a query to grab the date range about and combine it with another table for example if I had two tables

 

Table A

|id |listing_id| start_date | end_date|

 

 

Table B

| listing id | listing_name |

 

 

What I would like to do is query table A for * with start and end date and get the id

 

Create a second query to grab the listing name in table b

 

Combine the query results  to show is the listing name in the csv file that I will be exporting...

 

Did I lose you?

 

Thanks for your help..

 

 

[Muddy_Funster]

yeah, you did, why don't you just JOIN the tables on listing_id?

[ManiacDan]

Never use queries in a loop, always use a JOIN.

 

SELECT table_b.listing_id, listing_name, start_date, end_date
FROM Table_a
join table_b on table_a.listing_id = table_b.listing_id
WHERE (start_date BETWEEN '2011-08-01 00:00:00' AND '2011-08-31 00:00:00') AND (end_date BETWEEN '2011-08-01 00:00:00' AND '2011-08-31 00:00:00')

-Dan

[dk4210]

Thanks for your help!