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());
problem with Mktime in SQL sentence
Moderator: General Moderators
Re: problem with Mktime in SQL sentence
Please use the Code tag when posting code!! Make it easier to read.
You're looking for something like this:
You're looking for something like this:
Code: Select all
$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());