Mysql - Dates from . to .

Recording spans of time

[Wonderstuff]

Just starting out with Mysql - so making usual newbie mistakes.

I have a site that promotes a series of local events.

For example, a local museum has an exhibition from 22nd April to 3 September i.e. not just a single date but an inclusive span of time.

I'll then use PHP to present 'daily' information by venue on my website.

How should I start with 'from - to?'

Many thanks.

[justageek]

Take a look at the between operator. That will allow you to do something like:

select * from table where your_table_date between your_start_date and your_end_date

JAG

[Wonderstuff]

Thanks Justageek

That's the pointer that I was after.

Cheers - W