daveismyname said on 28/Sep/2009

Mon, 28 Sep 2009 04:20:27 UTC

Spotted a mistake the last line should be: $date= "$var_year-$var_day-$var_month";//join them all together to input into a mysql table

nkm said on 28/Sep/2009

Mon, 28 Sep 2009 05:59:35 UTC

MySQL date format is yyyy-mm-dd. Also, you should check if the date is correct.


	
function date_mysql($str)
{
	list($day, $month, $year) = explode('/', $str);

	if (checkdate((int) $month, (int) $day, (int) $year))
	{
		return $year.'-'.$month.'-'.$day;
	}

	return FALSE;
}

Comments on snippet: 'Date format for mysql input'

daveismyname said on 28/Sep/2009

nkm said on 28/Sep/2009