Data displaying problem

[182x]

Hey guys, I am using the following code to display data from my database however when the code has run it leaves space for the data but the data isn't actually displayed. Any suggestions? Thanks.

$sql = "SELECT * FROM acc";

$query = mysql_query($sql);

  while ( $row = mysql_fetch_array($query)) 
  {

        $data = $row['data'];

        echo $data." <br><br>";
  }

[NogDog]

Try replacing it with the following to see if it throws any useful errors:

$sql = "SELECT `data` FROM acc";
$query = mysql_query($sql) or die("Query failed: $sql - " . mysql_error());
while ( $row = mysql_fetch_array($query)) 
{
   if(!empty($row['data']))
   {
      $data = $row['data'];
      echo "$data<br><br>\n";
   }
   else
   {
      echo "<b style='color:red'>EMPTY</b><br><br>\n";
   }
}

[roscor]

Try this

mysql_connect($host,$username,$password);
mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM acc";

$result=mysql_query($query);
$num=mysql_num_rows($result);

if ($num==0) {


echo "No Matching Details on Database";

}
 else {
$num_rows = mysql_num_rows($result);

}

$i = 0;

while ($row = mysql_fetch_array($result)) {


$data = $row['data'];
?>


<tr>
<td><? echo "<td width='60 align='center'>$data";?></td>
</tr>
 <?
$i++;
}


echo "</table>";

?>