mysql query

[psnb]

I want to insert dates between January 1st of every year to December 31st of that year, to a table in mysql database.
If I insert manually, it takes 365 times from me to do this.
So is there any Sql Statements which can do this in minimum
attempt.

Example : "Insert into table set alldate='$dates' "

Date format is : dd-mm-yyyy.

[leatherback]

Hey psnb,

You can use the code which you got in the general help section by planetsim

$day = date("d");
$month = date("m");
$year = date("Y");

for ($i=0;$i<7;$i++)
{
    $time = mktime(0,0,0, $month, $day + $i, $year);
    echo date("d-m-Y", $time)." ";
}

You modify this to something like:

$day = 1;
$year = $startyear;

for ($i=0;$i<365;$i++)
{
    $time = mktime(0,0,0, 1, $day + $i, $year);
    echo date("d-m-Y", $time)." ";

// insert $time into database

}