Date function

[Dillenger]

Ok , so i've got this code to display the date for every monday:

$startMonday = mktime(12, 0, 0, 1, 5, 2004); 
		$sequence = 0; 
		for ($i = -1800; $i <= 1800; $i++) { 
   		 $date2[$i] = date('M d, Y', $startMonday + ($i * 7 * 24 * 60 * 60)); 

	 $sql = "select year from globals";
	 $result = mysql_query($sql);

	 $getyear = mysql_fetch_array($result);

	 $year = $getyear['year'];

	 if (substr($date2[$i], -2) == $year) { 
    	$monday[++$sequence] = $date2[$i]; 
		} 
	} 
	echo"<select name='updissue_date' size='1' class='boxes'>";

	foreach ($monday as $key => $value) 
	{

		if($value == $date)
		{
			echo"<option value='$value' selected>$value</option>";
		}
		else
		{
			echo"<option value='$value'>$value</option>";
		}

	}
	echo"</select>";

How do I make it so it will display YYYY-mm-dd as integers, so I can input that into a date field in the database?

[kingbear]

You can just use the strtotime() function to convert the dates into interger timestamps and store them in a DB.

[Dillenger]

how would i implement that into my current code though?

[Riddick]

$date_1 = date("Y-m-d", mktime(0, 0, 0, 1, 1, 2005));