problem with Mktime in SQL sentence
Posted: Wed Sep 30, 2009 9:28 am
hello all ,
i need to mix between SQL AND PHP , i need to check if the dates in the table the are between two dates that i have,
becuse this i need to use mktime to know this time in minutes
$query223 = mysql_query("
SELECT day As daylong,hour As hourlong,year As yearlong,mon As monlong,min As minlong,
(mktime(hourlong,minlong,0,monlong,daylong,yearlong)) As timed
FROM
Kings
WHERE Status='Win' && timed>123123123
") or die(mysql_error());
i need to mix between SQL AND PHP , i need to check if the dates in the table the are between two dates that i have,
becuse this i need to use mktime to know this time in minutes
$query223 = mysql_query("
SELECT day As daylong,hour As hourlong,year As yearlong,mon As monlong,min As minlong,
(mktime(hourlong,minlong,0,monlong,daylong,yearlong)) As timed
FROM
Kings
WHERE Status='Win' && timed>123123123
") or die(mysql_error());