Changeset 17532 for trunk/www/dch/shiftinfo.php

Timestamp:

01/21/14 01:37:43 (11 years ago)

Author:

Daniela Dorner

Message:

updated query to case-sensitive DB

File:

• trunk/www/dch/shiftinfo.php (modified) (1 diff)

trunk/www/dch/shiftinfo.php

@@ -24 +24 @@
 
 echo "<br> &nbsp;&nbsp;Night: ".$today." (date of sunset) <br>";
-$query="SELECT u FROM calendar.data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."' AND x=0 ";
+$query="SELECT u FROM calendar.Data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$today."' AND x=0 ";
 //echo $query;
 include ("db.php");