0
$verificatempo = mysql_query("SELECT * FROM logs
WHERE horario <= now() - INTERVAL 10 MINUTE
AND ip = '$ipaddress'
ORDER BY horario desc limit 1");
I would like to know the same date and time format as the now() which was used in mysql’s source line for comparison. If possible, it can be a code itself equal.
time is yyyy-mm-dd hh:ii:ss? or only time (hh:ii:ss)?
– rray
Format "YYYY-MM-DD HH-MM-SS" if used in a string context YYYYMMDDHHMMSS format if used in a numeric context in Mysql versions before Mysql 4.1.13 YYYYMMDDHHSS.uuuuuu format if used in a numeric context in Mysql 4.1.13 and newer versions
– CyberPro