Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PHP - Spot the Error

Posted on 2011-03-25
4
Medium Priority
?
240 Views
Last Modified: 2012-05-11
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();
		

	$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";

Open in new window

0
Comment
Question by:codemonkey2480
4 Comments
 
LVL 27

Expert Comment

by:Lukasz Chmielewski
ID: 35218401
I'm not sure if that shouldn't be
'".date('d', $yesterday)."-".date('m', $yesterday)."-".date('Y', $yesterday)." 18:00:00'
(- instead of . like in a date 03-25-2011 18:00
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 35218679
Looks to me like it's producing the correct values.  Here I've converted your code to just display the results. I get:

24.03.2011
24.03.2011:18:00:00','DD.MM.YYYY:HH24:MI:SS')
25.03.2011:14:19:00','DD.MM.YYYY:HH24:MI:SS')

Where is your error coming from?

http://us2.php.net/manual/en/function.date.php .

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
 "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>Untitled</title>
</head>
<body>
<?php 
$yesterday = mktime(0, 0, 0, date('m'), date('d')-1,   date('Y')); // determin what yesterday was
$now = time();
                
echo date("d.m.Y",$yesterday)."<br>";
echo date('d', $yesterday).".".date('m', $yesterday).".".date('Y', $yesterday).":18:00:00','DD.MM.YYYY:HH24:MI:SS')" ;
echo "<br>";
echo date('d', $now).".".date('m', $now).".".date('Y', $now).":".date('H', $now).":".date('i',$now).":00','DD.MM.YYYY:HH24:MI:SS')";

 ?>
</body>
</html>

Open in new window

0
 

Author Comment

by:codemonkey2480
ID: 35219314
Let me take  look.
0
 
LVL 5

Expert Comment

by:tsmgeek
ID: 35220036
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

Open in new window

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question