Welcome to WebmasterWorld Guest from 54.158.175.78

Forum Moderators: open

Message Too Old, No Replies

planning inserts in calendar

   
8:43 am on Dec 16, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi, I have now finished and managed to add the dates and properties at the same time to my calendar table.
So the table looks at this moment:
2012-12-01 property 1
2012-12-02 property 1
etc. until end of year
2012-12-01 property 2
2012-12-02 property 2
etc. until end of year (more properties to be added)

The next step is to update the table and add prices and description to make it easier to check the prices once done.
So now I wonder if for exampel I have rows with dates 1 january until 30 March description low then I have 1 April until 30 June description mid.
I know I can choose select low where property = property 1 however that will give me all rows from 1 january until 30 march.
I wonder if it is posible to select the first and last date for description low, so the result would be
property 1 low 2012-01-01
property 1 low 2012-03-30
That way I can check that the low season really ends when I want.

Thanks in advance
9:00 am on Dec 16, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hmm, just had a second thought, maybe better to add another columned named start and enddate, so when I update the calendar choosing the dates with the form, first I insert the start and end date to that column, then I add price and description to the dated between choosen dates, so I would only have to select column start and enddates and I will get start and enddates with its description, price and property.....
1:23 pm on Dec 16, 2011 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Deleted, a misstake sorry