I understand that it would be a problem if 'mm' or 'dd' only contained 1 digit, so I created this function to pad the numbers with zeros, so it is always the correct amount of digits.
Code: Select all
function padnumber($num,$length) {
$real_length = strlen($num);
if ($length > $real_length) {
return sprintf("%0".($length - $real_length)."d",$num);
}
return $num;
}
$start_date = padnumber($_POST['s_year'], 4).'.'.padnumber($_POST['s_mon'], 2).'.'.padnumber($_POST['s_mday'], 2);
$end_date = padnumber($_POST['e_year'], 4).'.'.padnumber($_POST['e_mon'], 2).'.'.padnumber($_POST['e_mday'], 2);Code: Select all
$sql .= ' AND REQUEST.TRANS_DATE >= \''.$start_date .'\' AND REQUEST.TRANS_DATE <= \''.$end_date.'\'';