creating special dates blocks

[dflow]

how would i setup special date blocks in date search?

for example easter this year is 17-04-2011 to 25-04-2011

 

for these dates each night will have an extra charge for it

 

now if a user checks 13-04-2011 to 18-04-2011 he will have 4 days of special charge

 

how do i setup this range?

 

 

[Fergal Andrews]

Hi dflow,

If you are looking for a MySQL search it would be:

 

SELECT * FROM mytable WHERE mydate BETWEEN '2011-04-17 00:00:00' AND '2011-04-25 23:59:59' 

 

cheers,

Fergal

[dflow]

Hi dflow,

If you are looking for a MySQL search it would be:

 

SELECT * FROM mytable WHERE mydate BETWEEN '2011-04-17 00:00:00' AND '2011-04-25 23:59:59' 

 

cheers,

Fergal

 

yes but it doesnt answer the question of specific days in that block