function printCategoryList() {
   global $locale, $DB_;
   $sql = "SELECT cat.cat_id, cat.cat_name, COALESCE(count(rec.rec_id),0) as recipes"
        ." FROM ".DB_RECIPES_CATEGORIES." cat LEFT OUTER JOIN ".DB_RECIPES_RECIPE." rec ON cat.cat_id = rec.cat_id"
        ." GROUP BY cat.cat_id, cat.cat_name ORDER BY cat.cat_id";
   $result = dbquery($sql);
   opentable($locale['REC200']);
   if (dbrows($result) != 0) {
      echo "<center><table width='500'>\n<tr>\n";
      echo "<td><strong>".$locale&#91;'REC201'&#93;."</strong></td>\n";
      echo "<td align='right'><strong>".$locale&#91;'REC202'&#93;."</strong></td>\n";
      echo "</tr>\n";
      while ($data = dbarray($result)) {
         echo "<tr>\n";
         echo "<td><a href='recipes.php?cat_id=".$data&#91;'cat_id'&#93;."'>".$data&#91;'cat_name'&#93;."</a></td>\n";
         echo "<td align='right'>".$data&#91;'recipes'&#93;."</td>\n";
         echo "</tr>\n";
      }
      echo "</table>\n</center>\n";
   }else {
      echo "<br /><center>".$locale&#91;'REC900'&#93;."</center><br />";
   }
   closetable();
}
gewandelt in 0.050 Sekunden, benutzt wurde GeSHi 1.0.8.10

function printCategoryContents($cat_id) {
   global $locale, $DB_;
   $result = dbquery("SELECT rec.*, cat.cat_name FROM ".DB_RECIPES_RECIPE." rec, ".DB_RECIPES_CATEGORIES." cat WHERE rec.cat_id=cat.cat_id AND cat.cat_id=".$cat_id);
   $data = dbarray($result);
   opentable($locale&#91;'REC100'&#93;."<em>".$data&#91;'cat_name'&#93;."</em>");
   // Checks if there are any returned rows
   if (dbrows($result) != 0) {
 
      echo "<table width='100%'>";
      echo "<tr><td><strong>".$locale&#91;'REC101'&#93;."</strong></td>\n<td><strong>".$locale&#91;'REC102'&#93;."</strong></td>\n</tr>\n";
      echo "<tr>\n";
      echo "<td><a href='recipes.php?action=view&amp;rec_id=".$data&#91;'rec_id'&#93;."'>".$data&#91;'rec_name'&#93;."</a></td>\n";
      echo "<td>".$data&#91;'rec_description'&#93;."</td>\n";
      echo "</tr>\n";
      while ($data = dbarray($result)) {
         echo "<tr>\n";
         echo "<td><a href='recipes.php?action=view&amp;rec_id=".$data&#91;'rec_id'&#93;."'>".$data&#91;'rec_name'&#93;."</a></td>\n";
         echo "<td>".$data&#91;'rec_description'&#93;."</td>\n";
         echo "</tr>\n";
      }
    echo "<tr>\n";
    echo "<td align='right' colspan='2'><a href='".INFUSIONS."rezepte_infusion/recipes.php' title='".$locale&#91;'REC070'&#93;."'><img src='".INFUSIONS."rezepte_infusion/img/category.gif' alt='".$locale&#91;'REC070'&#93;."' border='0' /></a></td>\n";
      echo "</tr>\n</table>\n";
   } else {
      echo "<center>".$locale&#91;'REC901'&#93;."<br /></center>";
      echo "<div align='right'><a href='".INFUSIONS."rezepte_infusion/recipes.php' title='".$locale&#91;'REC070'&#93;."'><img src='".INFUSIONS."rezepte_infusion/img/category.gif' alt='".$locale&#91;'REC070'&#93;."' border='0' /></a></div>\n";
   }
   closetable();
}
gewandelt in 0.054 Sekunden, benutzt wurde GeSHi 1.0.8.10

Parse error: syntax error, unexpected T_STRING in /var/www/web721/html/WFnew/infusions/rezepte_infusion/recipes.php on line 88
gewandelt in 0.069 Sekunden, benutzt wurde GeSHi 1.0.8.10