Hi everyone.

I am trying to construct a SELECT statement that calls data inbetween and including 2 dates.

At the moment, i am doing this

PHP Code:

SELECT * WHERE date BETWEEN '$from_date' AND '$to_date' 


But i have just realised that from_date and to_date data are not included within this statement.

Does anyone know how to call all the data inbetween two dates and include those dates as well?

Thanks in advance.

How do you call mysql_query() with that? Please provide the exact piece of code, not the variable string only.

BETWEEN includes boundaries, what you tell is quite strange.

Try this:

PHP Code:

"SELECT * FROM table_name WHERE date>='$from_date' AND date<='$to_date'"; 


Regards

Ian

Well if that's the case, all you have to do is push the $from_date back 1 and $to_date forwards one, mktime() should be ablt to do this for you i believe.

That'd be my round about way of doing it anyway.

Using the timestamp function will work, but provided the variables $from_date and $to_date are in the same format as the "date" column in the db table, it would mean unnecessary coding.

It all depends on the set up of the db table.

Hi everyone.

Sorry, but my email notification didn't seem to work. Let me try all of your solutions and i will get back in a few moments.

Ok. Thanks for the help everyone.

The email notification system didn't work and i thought that i had become hugely unpopular here and that no-one wanted to help. But all the contributions guided me towards finding/solving the problem.

The problem:
Upon investigation, i realised that `date` was a datetime. This meant that when i was searching dates without times. This meant that time was taken to be 00:00:00 and that is midnight of the previous night, hence the reason why end_date was not being included (except for transactions that may have taken place at midnight the previous night).

The solution:
By adding the time 23:59:59 (denoting the end of the day) to the end_date, the whole of end_date was included.

LET MY MISTAKES BE A LESSON TO ALL.

Thanks again.

Glad to be of assistance Fambi - I'm sure we've all spent many hours on similar omissions in our code/set-up!

Many hours indeed.

I think we're all in need of a holiday in Spain.