Cannot print the data from database in the webpage

Hi  all,

I am trying to run a query to retrieve data from mysql database and 
display it in a webpage in a table. The query is running fine, but the 
the data is not appearing on the webpage. All I see is a webpage with 
few empty cells. 

The echo command starting from line 42 is something like this
*echo "<tr>\n
            <td>$building</td>\n
            <td>$parking_lot</td>\n               
            <td>$month</td>\n   
            <td>$day</td>\n
            <td>$occupancy</td>\n
            <td>$empty_spaces</td>\n         
            <td>$special_days</td>\n
            </tr>\n";*

The variables I have used here ie., $building, $parking_lot etc are 
nothing but the column names in the mysql database ie., building, 
parking_lot etc. I hope I did not mess up in that sense. But, I do not 
know the reason for the non appearance of the data.

I am posting the whole code below. Also I am attaching a screenshot of 
the display in the webpage. If anyone has any answer please let me know.

Thanks
Sashi

<?php

// Connects to your Database
$host="******";
$user="******";
$password="******";
$dbname="******";
$cxn=mysqli_connect($host, $user, $password, $dbname) ;
if (!$cxn=mysqli_connect($host, $user, $password, $dbname))
    {
        $error=mysqli_error($cxn);
        echo "$error";
        die();
    }
else
    {
        echo "Connection established successfully";
    }
 
$sql="SELECT * FROM occupancy";
$data = mysqli_query($cxn,$sql);
if (!$data=mysqli_query($cxn,$sql))
    {
        $error=mysqli_error($cxn);
        echo "$error";
        die();
    }
else
    {
        echo "<br>";
        echo "Query sent successfully";
    }


echo "<br>";
echo "<h1> OCCUPANCY <h1>";
echo "<table cellspacing='0'>";
echo "<tr><td colspan='7'><hr /></td></tr>";
while ($row=mysqli_fetch_array($data))
    {
        extract($row);
        echo "<tr>\n
              <td>$building</td>\n
              <td>$parking_lot</td>\n                 
              <td>$month</td>\n  
              <td>$day</td>\n
              <td>$occupancy</td>\n
              <td>$empty_spaces</td>\n           
              <td>$special_days</td>\n
              </tr>\n";
        echo "<tr><td colspan='7'><hr /></td></tr>\n";
    }
    echo "</table>\n";


?>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sashikanth Gurram
Graduate Research Assistant
Department of Civil and Environmental Engineering
Virginia Tech
Blacksburg, VA 24060, USA