Sto godina se nisam bavio PHP. Bar ne nešto dublje. Sad imam jedan čudan problem. Kada za samu tabelu u SQL kucam:
HTML kod:
SELECT count(*) FROM controller WHERE rpidate BETWEEN DATE_SUB(now(), INTERVAL 5 MINUTE) AND now() AND deviceID = 7
Dobijem 0, i to i treba. Kada u PHP kucam ovo:
Kod:
$sql3=mysqli_query($con, "SELECT count(*) FROM controller WHERE rpidate BETWEEN DATE_SUB(now(), INTERVAL 5 MINUTE) AND now() AND deviceID = 7") or die (mysqli_error($con));
$numRows = mysqli_num_rows($sql3);
echo $numRows;
Dobijem 1. Šta nije u redu?