codemonkey2480
asked on
PHP - Spot the Error
Whats wrong with this query? I get an error "invalid month"
$yesterday = mktime(0, 0, 0, date('m'), date('d')-1, date('Y')); // determin what yesterday was
$now = time();
Also how do I find out the issue?
$yesterday = mktime(0, 0, 0, date('m'), date('d')-1, date('Y')); // determin what yesterday was
$now = time();
Also how do I find out the issue?
$yesterday = mktime(0, 0, 0, date('m'), date('d')-1, date('Y')); // determin what yesterday was
$now = time();
$reports_sql = "Select log.clientid,cm.name,log.message,log.LOGSTAMP
From admin_log log, client_master cm
Where
log.clientid=cm.clientid AND
log.logstamp >= TO_TIMESTAMP('".date('d', $yesterday).".".date('m', $yesterday).".".date('Y', $yesterday).":18:00:00','DD.MM.YYYY:HH24:MI:SS')
AND
log.logstamp < TO_TIMESTAMP('".date('d', $now).".".date('m', $now).".".date('Y', $now).":".date('H', $now).":".date('i', $now).":00','DD.MM.YYYY:HH24:MI:SS')
Order by ClientId";
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Let me take look.
SELECT log.clientid,cm.name,log.message,log.logstamp
FROM admin_log log, client_master cm
WHERE
log.clientid = cm.clientid
AND
log.logstamp >= CURRENT_TIMESTAMP - INTERVAL 1 DAY
ORDER BY log.clientid
'".date('d', $yesterday)."-".date('m', $yesterday)."-".date('Y', $yesterday)." 18:00:00'
(- instead of . like in a date 03-25-2011 18:00