/////// PRODUCT DATABASE /////////
if ($_GET['p'] == "pdb") {
    MySQLConnect();
    MySQLSelDB("reeciebo_siteroot");

    $query = mysql_query($SQL_PDB_Gather);
    $numRows = mysql_num_rows($query);

    for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_gather` in $GATHER[$i]['arg']
        $prodname = mysql_result($query, $i, "prodname"); $prodcost = mysql_result($query, $i, "prodcost");
        $prodlink = mysql_result($query, $i, "prodlink"); $proddesc = mysql_result($query, $i, "proddesc");
        $GATHER = array($i => array("prodname" => $prodname, "prodcost" => $prodcost, "prodlink" => $prodlink, "proddesc" => $proddesc));
    }

    $query = mysql_query($SQL_PDB_Leveling);
    $numRows = mysql_num_rows($query);

    for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_leveling` in $LEVELING[$i]['arg']
        $prodname = mysql_result($query, $i, "prodname"); $prodcost = mysql_result($query, $i, "prodcost");
        $prodlink = mysql_result($query, $i, "prodlink"); $proddesc = mysql_result($query, $i, "proddesc");
        $LEVELING = array($i => array("prodname" => $prodname, "prodcost" => $prodcost, "prodlink" => $prodlink, "proddesc" => $proddesc));
    }

    $query = mysql_query($SQL_PDB_PVP);
    $numRows = mysql_num_rows($query);

    for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_leveling` in $PVP[$i]['arg']
        $prodname = mysql_result($query, $i, "prodname"); $prodcost = mysql_result($query, $i, "prodcost");
        $prodlink = mysql_result($query, $i, "prodlink"); $proddesc = mysql_result($query, $i, "proddesc");
        $PVP = array($i => array("prodname" => $prodname, "prodcost" => $prodcost, "prodlink" => $prodlink, "proddesc" => $proddesc));
    }

    $query = mysql_query($SQL_PDB_Packs);
    $numRows = mysql_num_rows($query);

    for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_leveling` in $PACKS[$i]['arg']
        $prodname = mysql_result($query, $i, "prodname"); $prodcost = mysql_result($query, $i, "prodcost");
        $prodlink = mysql_result($query, $i, "prodlink"); $proddesc = mysql_result($query, $i, "proddesc");
        $PACKS = array($i => array("prodname" => $prodname, "prodcost" => $prodcost, "prodlink" => $prodlink, "proddesc" => $proddesc));
    }

    // Start Organising the tables.
    /// Gathering Table

    $temp = "<tr><td>&nbsp;</td><td>";
    $i = 0;
    $x = 1;
    while ($GATHER[$i]) {
        $temp = $temp.$x.". ".$GATHER[$i]['prodname']."<br/>";
        $i++;
        $x++;
    }
    $temp = $temp."</td></tr>";
    $table1 = Table_Create("PRODUCT JUMP", $temp);
    $pageContents = print_r($GATHER);

}


//////////////////////////////////
// FUNCTIONS /////////////////////
//////////////////////////////////

function MySQLConnect() {
    $host = "localhost";
    $user = "removed";
    $pass = "removed";
      $conn = mysql_connect($host, $user, $pass) or die(mysql_error());
}
function MySQLSelDB($db) {
    $seldb = mysql_select_db($db) or die(mysql_error());
}
function Table_Create($pageHeader, $pageBlob) {
        return "<table width='95%' border='0' cellspacing='0' cellpadding='0'><tr><td colspan='2' align='center' height='22' bgcolor='#89BAD8'><span class='headertext'>".$pageHeader."</span></td></tr>".$pageBlob."</table>";

}