Re: [PHP] calendar Q

2006-08-12 Thread Richard Lynch
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

RE: [PHP] calendar Q

2006-08-11 Thread Jef Sullivan
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

Re: [PHP] calendar Q

2006-08-10 Thread William Stokes
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

Re: [PHP] calendar Q

2006-08-10 Thread Richard Lynch
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 >

Re: [PHP] calendar Q

2006-08-10 Thread Brad Bonkoski
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