Jump to content

MADTinus

New Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by MADTinus

  1. Hello there,

    I've made a very simple file to put some requested data in a tabel-form. Somehow first the output starts with about 60-70 blank lines, and then the output. Somewere I made a mistake, but the longer I look, the harder it get tot see.

     

    Please can someone show me the mistake. See below/

    Thanks,

    Martin.

     

    Programlines:

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
     
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
     
    <title>Output data from Complex</title>
    </head>
     
     
    <?php
     
    # MRouw: deze file maakt de connectie met de database
    require ('connectdb.php');
     
    // MRouw: hier haal je de gewenste velden op uit de gewenste tabel
    $sql = "SELECT Complexnaam, Adres, Plaats FROM complex";
    $result = $conn->query($sql);
     
    # Heater-row
    echo "<table border=2 cellpadding=0 cellspacing=0>";
    echo "<td><b>Complexnaam</b></td><td><b>Adres</b></td><td><b>Plaats</b></td>"; 
     
        while($row = $result->fetch_assoc()) {
            echo '
    <tr>
                <td>' . $row['Complexnaam'] . '</td>
                <td>' . $row['Adres'] . '</td>
    <td>' . $row['Plaats'] . '</td>
    </tr>
    <br>
        ';
    ;
        }
     
    $conn->close();
     
    ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.