MySQL at returned an error:




 

"; break; case "word95": return ""; break; case "word95zip": return ""; break; case "word6": return ""; break; case "word6zip": return ""; break; case "wordzip": return ""; break; case "wpd": return ""; break; case "wpdzip": return ""; break; case "pdf": return ""; break; case "rtf": return ""; break; case "zip": return ""; break; default: return ""; } } ################################################################## # Hier ist die eigentliche Abfrage ################################################################## function germandate($database,$dblink,$date){ $query="SELECT dayofmonth('$date'),month('$date'),year('$date')"; /* mysql_free_result($result); */ $result = mysql_db_query($database,$query,$dblink); $row = mysql_fetch_row($result); return $row[0].".".$row[1].".".$row[2]; } function getday($database,$dblink,$date){ $query="SELECT dayofmonth('$date')"; /* mysql_free_result($result1);*/ $result = mysql_db_query($database,$query,$dblink); $row = mysql_fetch_row($result); return $row[0]; } function getmonth($database,$dblink,$date){ $query="SELECT month('$date')"; /* mysql_free_result($result1);*/ $result = mysql_db_query($database,$query,$dblink); $row = mysql_fetch_row($result); return $row[0]; } function abfrage_uebersicht($database,$dblink,$date){ global $id; if (!$id){ if ($date=="old"){ $query="SELECT id,titel,von,bis,(to_days(bis)-to_days(von)) FROM aktuelles where (verfallsdatum0){ echo ""; while($rowno--){ echo ""; } echo ""; echo "
"; $row = mysql_fetch_row($result); for($i=0; $i· "; if (strlen($row[3])==0) echo germandate($database,$dblink,$row[2]); else { if ($row[4]=='1') echo getday($database,$dblink,$row[2])."./".germandate($database,$dblink,$row[3]); else if ($row[4]=='0') echo germandate($database,$dblink,$row[2]); else echo germandate($database,$dblink,$row[2])." - ".germandate($database,$dblink,$row[3]); } echo " $row[1]
hinzufügen
"; } mysql_free_result($result); } function abfrage_eintraege($database,$dblink,$date){ global $id; if (!$id){ if ($date=="old"){ $query="SELECT id,titel,text,link,linktext,file,filesize,filetype, filetypedescription, filedescription, von, bis,(to_days(bis)-to_days(von)) FROM aktuelles where (verfallsdatum0){ while($rowno--){ $row = mysql_fetch_row($result); for($i=0; $i
$row_titeledit
\n"; // if (strlen($row_to)==0) // echo "