On Fri, August 11, 2006 12:23 am, William Stokes wrote:
> One more question. I have dates as a datetime in DB. Like 2006-08-11
> 08:20:00 and I'm playing only with date part in the calendar
> 2006-08-11. So
> how to compare this date to the datetime info in DB? Do I need to use
> DATE_FORMAT or som
Original Message-
From: William Stokes [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 11:23 PM
To: php-general@lists.php.net
Subject: Re: [PHP] calendar Q
Ok. Thanks.
One more question. I have dates as a datetime in DB. Like 2006-08-11
08:20:00 and I'm playing only with date
Ok. Thanks.
One more question. I have dates as a datetime in DB. Like 2006-08-11
08:20:00 and I'm playing only with date part in the calendar 2006-08-11. So
how to compare this date to the datetime info in DB? Do I need to use
DATE_FORMAT or someting like this in the query?
Thanks
-Will
""R
On Thu, August 10, 2006 12:14 pm, William Stokes wrote:
> I have a calendar script that displays a simple mini calendar view one
> month
> at a time. User can click any date and the calendar opens another page
> that
> displays that date's events. I would like to highlight to the mini
> calendar
>
Really depends on how you display the calendar...
if you go day by day building the table cells, then it should be easy
enough because you should already have the date you are working with...
so a query like "select count(*) from events where date='date'" and if
count is > 0 then display it diff
Hello,
I have a calendar script that displays a simple mini calendar view one month
at a time. User can click any date and the calendar opens another page that
displays that date's events. I would like to highlight to the mini calendar
view dates that have an event in database. So what would be
6 matches
Mail list logo
