Menu
iam using mssql-server with php.
now i have a field with type of int.. and i sotred a date
in this field in unix timestamp after i conver them using this function:
[code=php]
function date_to_timestamp($time) {
$timeArray = explode(“-“, $time);
if(count($timeArray)) {
$y = $timeArray[0];
$m = $timeArray[1];
$d = $timeArray[2];
return mktime(0,0, 0, $m,$d,$y);
}
return false;
}
now, how can make a query that will only list all records with a prticular month…
lets say i want to pass 1 for Jan, 2 for Feb and 3 for March, etc…
pass this int to my query get all records with this month
any idea
Thanks
M