Untitled

<?php
session_start();
$dbhost = 'mysql2.000webhost.com';
$dbuser = 'a1059070_Alexi';
$dbpass = 'stricked101';
$con=mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error Connection to MySQL');
$dbname = 'a1059070_users';
mysql_select_db($dbname);
$id=$_SESSION['id'];
$query = "SELECT * FROM news ORDER BY newsid DESC";
$result = mysql_query($query) or die(mysql_error());
// Instead, we're not going to make the row here.

?>


<html>
<head>
<title>Untitled Document</title>
</head>

<body>
<table width="100%" border="1">
  <tr>
    <td width="15%" height="87" align="center">Logo</td>
    <td width="85%"><table width="100%" height="72" border="0">
      <tr>
        <td width="25%" height="66" align="center" valign="bottom">Complaints/Inquiries</td>
        <td width="25%" align="center" valign="bottom">Messages</td>
        <td width="25%" align="center" valign="bottom">Edit Staff</td>
        <td width="25%" align="center" valign="bottom">Reports</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="567"><table width="100%" height="505"  align="right"border="0">
      <tr>
        <td align="right"><a href="news.php" target="_self">Edit News</a></td>
      </tr>
      <tr>
        <td align="right">Server Status</td>
      </tr>
      <tr>
        <td align="right">Donation Prices</td>
      </tr>
      <tr>
        <td align="right">Donation Records</td>
      </tr>
      <tr>
        <td align="right">Donation List</td>
      </tr>
      <tr>
        <td align="right">Set Exp Events</td>
      </tr>
      <tr>
        <td height="10%" align="right">Vote Records</td>
      </tr>
      <tr>
        <td height="10%" align="right">Ip Bans</td>
      </tr>
      <tr>
        <td height="10%" align="right">Give Item</td>
      </tr>
      <tr>
        <td height="10%" align="right">Online Players</td>
      </tr>
    </table></td>
    <td><table width="100%" height="514" border="0">
      <tr>
        <td width="49%" height="508" align="right" valign="top">

        <h1 align="center"> Edit News </h1><br><br>
        <form method="post" name="newsedit" action="newsupdate.php">
        Title <input type="text" name="newstitle">Name<input type="text" name="newsname"><br><br>
        <textarea name="newscontent" rows="16" cols="65"> </textarea><br>
        <input type="submit" name="newssubmit" value="Post">


        </form>


        </td>
        <td width="51%" align="right" valign="top">

        <h1 align="center"> Preview </h1>


        <br>

 <?php

 echo "<table width='100%' border='1'>";
// HERE is where we get the row, and we loop over it over and over
while ($row = mysql_fetch_array($result)) {


echo  "<tr>";
echo    "<td width='11%' height='54'>&nbsp;</td>";
echo    "<td width='89%'><table width='100%' border='1'>";
// I broke this stuff, out it back in
echo    "<td height='422'>&nbsp;</td>";
echo    "<td align='center' valign='middle'><h4>" . $row['DATA'] . "</h4></td>";
echo  "</tr>";

}

echo "</table>";

?>


       </td>
      </tr>
    </table></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>