Hi, my query doesn't work, I've got a date field in my MySql table, I want to get results of all employees that was added in a certain period. My query doesn't work but as soon as I type in values in my query instead of variables it works, what am I doing wrong?
$date = date('Y/m');
$date1 = strtotime('-6 month');
$date2 = strtotime('-6 month');
echo date('Y', $date1);
echo date('m', $date2);
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbname", $con);
$sql = "SELECT * FROM detail WHERE year(engaged) > '$date1' and month(engaged) > '$date2'";
$result=mysql_query($sql);
echo mysql_num_rows($result);