Untitled

<html>
<head>
<title>GTA V Mission Info - Current Uploaded Missions</title>
</head>
<body>
<?php
            //Variables for connecting to your database.
            //These variable values come from your hosting account.
            $hostname = "PRIVATE";
            $username = "PRIVATE";
            $dbname = "PRIVATE";

            //These variable values need to be changed by you before deploying
            $password = "PRIVATE";
            $usertable = "Missions";

            //Connecting to your database
            mysql_connect($hostname, $username, $password) OR DIE ("Unable to
            connect to database! Please try again later.");
            mysql_select_db($dbname);

        $data = mysql_query("SELECT * FROM Missions ORDER BY CashPayout DESC")
        or die(mysql_error());
            $info = mysql_fetch_array( $data );

            Print "<table border cellpadding=3>";
        Print "<tr><td width=200px>Mission Name</td><td width=100px>Contact</td><td width=100px>Rank</td><td width=100px>Cash Payout</td><td width=100px>RP Payout</td><td width=50px>Min Players</td><td width=50px>Max Players</td><td width=270px>Mission Overview</td><td width=270px>Mission Tips</td><td width=60px></td></tr>";

        while($info = mysql_fetch_array( $data ))
            {
        Print "<tr><td>" . $info['MissionName'] . "</td>";
                Print "<td>" . $info['Contact'] . " </td>";
        Print "<td>" . $info['Rank'] . " </td>";
        Print "<td>" . $info['CashPayout'] . " </td>";
        Print "<td>" . $info['RPPayout'] . " </td>";
        Print "<td>" . $info['MinPlayers'] . " </td>";
        Print "<td>" . $info['MaxPlayers'] . " </td>";
        Print "<td>" . $info['Desc'] . " </td>";
        Print "<td>" . $info['Tips'] . " </td>";
        Print "<td><a href=\"editentry.php?id=$info[MissionNumber]\">Edit</a></td></td></tr>";
            }
            Print "</table>";

            mysql_close(); //Make sure to close out the database connection
?>
</body>
</html>