Hey guys im trying to connect to an database and collect some data out of the table zuordnung but it doesn't work correct everything i get is a white page im frustated because i can't find the error mabye another pair of eyes sees it so here is what i have so far:
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
include ("db_login.php");
$link = mysql_connect($host, $user, $pass) or die ("Keine Verbindung zu der Datenbank moeglich.");
mysql_select_db($db, $link);
$sql = "SELECT ID_Zuordnung, HW_Typ, Hostname_alt, Username, Emailadresse, Datum_Ausgabe, Abteilung
FROM zuordnung
WHERE Status_Tausch='OK' AND Status_Altgeraet='NOK'
ORDER BY Hostname_alt;";
$result = mysql_query($sql);
$resultarray = mysql_fetch_array($result);
echo('<p>'.$resultarray['HW_Typ']."</p>");
echo('<p>'.$resultarray['Hostname_alt']."</p>");
echo('<p>'.$resultarray['Username']."</p>");
echo('<p>'.$resultarray['Emailadresse']."</p>");
echo('<p>'.$resultarray['Datum_Ausgabe']."</p>");
echo('<p>'.$resultarray['Abteilung']."</p>");
?>
</body>
</html>
while($resultarray = mysql_fetch_array($result))
{
echo('<p>'.$resultarray['HW_Typ']."</p>");
echo('<p>'.$resultarray['Hostname_alt']."</p>");
echo('<p>'.$resultarray['Username']."</p>");
echo('<p>'.$resultarray['Emailadresse']."</p>");
echo('<p>'.$resultarray['Datum_Ausgabe']."</p>");
echo('<p>'.$resultarray['Abteilung']."</p>");
}
try this
require_once($_SERVER['DOCUMENT_ROOT']."db_login.php");
instead of Include
and u need to echo resultarray in a while loop if u are having more than 1 record.
are u forgotten to loop
use loop,like this.
while($resultarray = mysql_fetch_array($result))
{
echo('<p>'.$resultarray['HW_Typ']."</p>");
echo('<p>'.$resultarray['Hostname_alt']."</p>");
echo('<p>'.$resultarray['Username']."</p>");
echo('<p>'.$resultarray['Emailadresse']."</p>");
echo('<p>'.$resultarray['Datum_Ausgabe']."</p>");
echo('<p>'.$resultarray['Abteilung']."</p>");
}