homepage Welcome to WebmasterWorld Guest from 107.22.141.14
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
planning inserts in calendar
helenp




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

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

 

helenp




msg:4398527
 9:00 am on Dec 16, 2011 (gmt 0)

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.....

helenp




msg:4398623
 1:23 pm on Dec 16, 2011 (gmt 0)

Deleted, a misstake sorry

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved