Hello @all
i'm having a mayor problem wich i tought was easy.
i have a database with 365 products representing each day of this year.
this is how i setted up my database:
Table calendar
calendar_id int(11) No 0 (for all yearday)
did int(11) No 0 (for calandarday)
calendar_date date No 0000-00-00 (full date)
calendar_id|did|calendar_date
1, 1, '2006-01-01'
2, 2, '2006-01-02'
3, 3, '2006-01-03'
4, 4, '2006-01-04'
5, 5, '2006-01-05'
6, 6, '2006-01-06'
7, 7, '2006-01-07'
8, 8, '2006-01-08'
9, 9, '2006-01-09'
10, 10, '2006-01-10'
11, 11, '2006-01-11'
12, 12, '2006-01-12'
etc,etc
244, 1, '2006-09-01'
I want to create a calendar structure with this information provided.
so my products page must go look like a calendar.
ofcourse it is required to print it out in the correct date/time firstday of the week etc etc.
I really have no clue how to proceed.
Can someone help me with this.
GrtZZ
wHiTeHaT