Database connection failed due to ".mysql_error()."

"); $error=true; } } if (!$error) { echo ("

Wetter der letzten 7 Tage.

\n"); $query="SELECT COUNT(*), AVG(`tempout`), AVG(`humout`), AVG(`windgust`), SUM(`raindif`) FROM `frewe_history` WHERE `datetime`>= DATE_SUB(NOW(), INTERVAL 7 DAY)"; print_results($query, $dbconnection); } function print_results($query, $dbconnection) { $error=false; if (!$error && !($result=@mysql_query($query, $dbconnection))) { echo ("

Error with query.

\n"); echo ("

Query: ".trim(nl2br(htmlentities($query)))."

\n"); echo ("

MySQL: ".mysql_error()."

\n"); $error=true; } else if (!$error && ($rows_left=mysql_num_rows($result))<1) { echo ("

No records found for query.

\n"); $error=true; } else if (!$error) { for ($i=0;$row=mysql_fetch_assoc($result);$i++) { if ($i==0) { echo ("
"); foreach ($row as $key=>$value) echo ("
".$key."
"); echo ("
\n"); } echo ("
"); foreach ($row as $key=>$value) echo ("
".$value."
"); echo ("
\n"); echo ("
\n"); } } return $error; } ?>