May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
$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";
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to get chosen background-color on every line?||10||44|
|how to use a foreach loop in heredoc used to send email via php||14||42|
|insert ID of database value into database instead of text value from text field||44||60|
|How to convert PHP array into string ?||16||28|
Join the community of 500,000 technology professionals and ask your questions.