problems with my php code output of sql

Question

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>

your include command has a space inside, I would guess that this makes trouble. — Nicole Stutz
– Nicole Stutz, Commented Oct 8, 2012 at 13:01
test if mysql_select_db works. Test if $result is valid. Call mysql_last_error(). Basically - debug it! — Andrew Hall
– Andrew Hall, Commented Oct 8, 2012 at 13:01
Have a look at this: php.net/manual/en/function.mysql-error.php — Andrew Hall
– Andrew Hall, Commented Oct 8, 2012 at 13:25
@AndrewHall ok tried their sample and got an 0 what does this now mean for me? — Alesfatalis
– Alesfatalis, Commented Oct 8, 2012 at 13:38

Nirav Ranpara · Accepted Answer · 2012-10-08 13:01:32Z

1

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>");

}

answered Oct 8, 2012 at 13:01

Nirav Ranpara

13.8k4 gold badges43 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nirav Ranpara Over a year ago

I think there is no data in your database . check whether is it single data ?

Aditya Kumar · Accepted Answer · 2012-10-08 13:03:30Z

0

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.

answered Oct 8, 2012 at 13:03

Aditya Kumar

7931 gold badge8 silver badges14 bronze badges

Comments

Ravindra Bagale · Accepted Answer · 2012-10-08 13:05:13Z

0

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>");

}

answered Oct 8, 2012 at 13:05

Ravindra Bagale

17.7k9 gold badges46 silver badges70 bronze badges

Collectives™ on Stack Overflow

problems with my php code output of sql

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related