Code:
$sql="SELECT * FROM my_table
WHERE ent_date BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')";
$sql="SELECT * FROM my_table
WHERE ent_date BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')";
Code:
if ($result=mysqli_query($conn,$sql))
{
// Return the number of rows in result set
$rowcount=mysqli_num_rows($result);
printf(" %d\n",$rowcount);
// Free result set
mysqli_free_result($result);
}
if ($result=mysqli_query($conn,$sql))
{
// Return the number of rows in result set
$rowcount=mysqli_num_rows($result);
printf(" %d\n",$rowcount);
// Free result set
mysqli_free_result($result);
}
Kada pokrenem preko XAMPP-a u localhostu, dobijam rezultat, medjutim kada ga podignem na server, ispisuje mi 0 rezultata.
MySQL verzija na serveru je: 5.6.32-78.1
Koja to komanda iz query-a nije podrzana tom verzijom?