Php - Nyhedssystem med bruger login

PHP kode 

 if(!$_GET[valg] == "skrivok") {
     $hent = mysql_query("SELECT * FROM news ORDER BY id DESC") or die(mysql_error());
     if(mysql_num_rows($hent)) {
         while($vis = mysql_fetch_array($hent)) {
         $url = 'comments.php?id='.$vis['id'];
 ?>
 <table border="0" width="100%" class="test" >
     <tr>
         <td>
             <table class="left" border="0" width="100%">
                 <tr>
                     <td><h2><? echo $vis[overskrift]; ?></h2></td>
                 </tr>
                 <tr>
                     <td class="borderstreg">Skrevet af <b><? echo $vis[user_id]; ?></b> - <? echo $vis[dato]; ?></td>
                 </tr>
                 <tr>
                     <td><? echo nl2br($vis[besked]); ?></td>
                 </tr>
                 <tr>
                     <td><A HREF="javascript:void(0)" onclick="window.open('<?php echo $url ?>', 'welcome','width=600,height=600')">Tilføj eller se kommentare</A>
                     <hr /></td>
                 </tr>
             </table>
         </td>
     </tr>
 </table>
 <td class="borderstreg"></td>
 <?
         }
     } else {
         echo("Der blev intet fundet i databasen.");
     }
 }

PHP kode 

 if(!$_GET[valg] == "skrivok") {
     $query = mysql_query("SELECT * FROM news INNER JOIN users ON news.user_id = users.id ORDER BY news.id ASC");
     while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
         echo $row['username'];
     }
 }

SQL kode 

 id, overskrift, besked, dato, user_id
 PRIMARY - id
 INDEX - user_id

SQL kode 

 id, fullname, email, username, password, date, ip
 PRIMARY - id

PHP kode 

 $query = mysql_query("SELECT * FROM news INNER JOIN users ON news.user_id = users.id ORDER BY news.id ASC");
     while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
         echo $row['overskrift'];
         echo $row['besked'];
         echo $row['dato'];
         echo $row['user_id'];
     }

PHP kode 

 if(!$_GET[valg] == "skrivok") {
     $query = mysql_query("SELECT * FROM news ORDER BY id DESC");
     if(mysql_num_rows($query)) {
         while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
         ?>
             <table border="0" width="100%" class="test" >
                 <tr>
                     <td>
                         <table class="left" border="0" width="100%">
                             <tr>
                                 <td><h2><? echo $row[overskrift]; ?></h2></td>
                             </tr>
                             <tr>
                                 <td class="borderstreg">Skrevet af <b><? echo $row[user_id]; ?></b> - <? echo $row[dato]; ?></td>
                             </tr>
                             <tr>
                                 <td><? echo nl2br($row[besked]); ?></td>
                             </tr>
                             <tr>
                                 <td><A HREF="javascript:void(0)" onclick="window.open('<?php echo $url ?>', 'welcome','width=600,height=600')">Tilføj eller se kommentare</A>
                                 <hr /></td>
                             </tr>
                         </table>
                     </td>
                 </tr>
             </table>
         <?php
         }
     } else {
         echo("<h1>Vær den første til at skrive en nyhed!</h1>");
     }
 }