Problem With Date!! PLEASE HELP

hwij3

I have a field in my table in the form of timestamp (including the hour,minute,and second).
I want to compare a date (which only contain day,month,and year) to my timestamp field in the table.
How do I do that? Because if I use mktime( ) I need to set the hour,minute,and sec. I dont want to do that.
I want to compare the day,month,and year only. Please HELPPP
Thank you so much

Quevas

Just set hours, minutes and seconds to 0.

hwij3

No I can't. Because my timestamp in table include hours,minutes, and seconds which are not 0.
But I just want to compare the day,month,year.
example:
20 October 2002 10:45:30
should be the same as
20 October 2002 00:00:00

Weedpacket

No, that would work.

$timestamp=mktime(10, 45, 30, 10, 20, 2002); // Really it would come out of the table.
list($day, $month, $year) = explode(' ', date('d m Y', $timestamp));
$timestamp = mktime(0, 0, 0, $month, $day, $year);
echo date('d M Y, H:i:s', $timestamp);

hwij3

I've tried it and it doesnt work. Probably I didn't explain my problem clearly sorry for that.
Here is the situation:
I have a field called event_date in a table called Event.
event_date store the date in timestamp form (eg:1041347340)
That is 1 January 2003 02:09:00

Then in a page I want to display something if lets say the date is 1 January 2003 (no matter what the time is).
It looks like this:
......
if(haveEvent($Day_Counter,$Month,$Year))
printf("PRINTED");
......

function haveEvent($day,$mon,$year)
{
//THIS LINE BELOW IS THE PROBLEM
$timestmp = mktime(0,0,0,$mon,$day,$year);

$result = mysql_query("SELECT * FROM event WHERE event_date='$timestmp'");
if(! $result)
die ("haveEvent fatal error: ".mysql_error());
return mysql_fetch_array($result);
}

But "PRINTED" would not be printed because the hour,minute,second is different.
I tried to debug and change
$timestmp = mktime(2,9,0,$mon,$day,$year);

and it did print PRINTED.

I hope that clarify the situation.
I really appreciate any help.

shamly

make 2 timestamps

$timestmp = mktime(0,0,0,$mon,$day,$year);

$timestmp1 = mktime(23,59,59,$mon,$day,$year);

then try this sql statement

$result = mysql_query("SELECT * FROM event WHERE event_date between '$timestmp' and '$timestmp1'");

this should return the data u want

hwij3

Excellent!!! It works!!
Thank you very much Shamly.
Ive been trying to solve it for hours. Newbie here 😃
Thanksss