无法显示关系表类别新闻

我正在尝试从与类别表相关的表中回显数据，但我没有得到它来显示数据，出了点问题。

下面是一些代码：

tbl_category_news- id_category_news
-类别

tbl_news- id_news
- id_category_news
-标题
-描述
-.msg
-name_arquive
-传说

 <?php
     $categoryId = 1; 
      $sql_visualizar = mysql_query("SELECT * FROM tbl_news AS t1 JOIN tbl_category_news c
    ON c.id_category_news=t1.id_category_news WHERE id_category_news = {$categoryId}");
    while($linha = mysql_fetch_array($sql_visualizar)){
    $title = $linha ['title'];
    $description = $linha['description'];
    $msg = $linha['msg'];
    $legend = $linha['legend'];
    $nome_arquive = $linha['name_arquive'];
    $id_news = $linha['id_news'];
      ?>
<?php echo $msg?>
<?php
  }
  ?>