Changeset 17507 for schedule/Module/calendar.php

Timestamp:

01/13/14 12:27:29 (11 years ago)

Author:

tose

Message:

Modified query fetching dates with schedule

File:

• schedule/Module/calendar.php (modified) (1 diff)

schedule/Module/calendar.php

@@ -31 +31 @@
                    var DATE_INFO = {
                         <?php
-                                $sqlSched=mysql_query("SELECT*FROM schedule");
+                                $sqlSched=mysql_query("SELECT DISTINCT(date(fStart)) AS SchedDate FROM schedule");
                                 $SchedCnt=mysql_num_rows($sqlSched);
                                 $src=1;
                                 while($rowSched=mysql_fetch_array($sqlSched))
                                 {
-                                        $timestamp=strtotime($rowSched['fStart']);
+                                        $timestamp=strtotime($rowSched['SchedDate']);
                                         if($SchedCnt==$src) 
                                         {