Care2007/include/inc_cafe_get_menu.php

   1 <?php
   2 $dbtable_menu='care_cafe_menu';
   3
   4 /* Check whether the content is language dependent */
   5 if(defined('LANG_DEPENDENT') && (LANG_DEPENDENT==1)) {
   6         /* Set the sql query for fetching the menu */
   7     $sql_menu="SELECT menu FROM $dbtable_menu WHERE cdate='".date("Y-m-d")."' AND lang='".$lang."'";
   8 }
   9 else {
  10         /* Set the sql query for fetching the menu */
  11     $sql_menu="SELECT menu FROM $dbtable_menu WHERE cdate='".date("Y-m-d")."'";
  12 }
  13
  14 if($ergebnis=$db->Execute($sql_menu)) {
  15
  16         if($rows=$ergebnis->RecordCount()) {
  17             $menu = $ergebnis->FetchRow();
  18         }
  19         else {
  20             $menu['menu']=$LDNoMenu;
  21     }
  22 }
  23
  24 if(!$menu['menu']) $menu['menu']=$LDNoMenu;
  25
  26 ?>