output a year calendar as .sql file

[Henry Withoot]

Hello to all

I was wondering if it is posseble to create a full year calendar as a mysql table
so the table is called calendar
and its data contain from
1 to 365

id 1 = 01-01-2006
id 2 = 02-01-2006
ofcourse in a structure that fits the actual year.
I need this as such list go represent products.
Thanks in Advance.

Also , if this is posseble and is apropiate to ask here, how to format this data to a calendar structure in php
so have a month view for a whole year.



Edited 1 time(s). Last edit at 10/08/2006 06:10AM by Henry Withoot.