$total = 0;
$result = mysql_query("SELECT * FROM pledges WHERE `user_id`='{$usernameid}' AND `deleted_at` IS NULL") or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
    $campaignID = $row['campaign_id'];
    $amount = $row['amount_cents'];
    $since = $row['created_at'];
    $total += $amount;
    $amount = getInFullDollar($amount);
    $resultCamp = mysql_query("SELECT * FROM campaigns WHERE `campaign_id`='{$campaignID}'");
    $rowCamp = mysql_fetch_array($resultCamp);
    $campaign = $rowCamp['creation_name'];
    echo "<b>{$campaign}</b> (<a href='GetCampaign.php?campaignid={$campaignID}'>{$campaignID}</a>)<br/>with <b>\${$amount}</b> - Since: <b>{$since}</b><br/><br/>";
}
$total = getInFullDollar($total);
echo "-------------------<br/><b>Total: \${$total}</b><br/>-------------------<br/>";
$result = mysql_query("SELECT * FROM pledges WHERE `user_id`='{$usernameid}' AND `deleted_at` IS NOT NULL") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    echo "<br/>{$userFirstName} was supporting:<br/>";
}
while ($row = mysql_fetch_assoc($result)) {
    $campaignID = $row['campaign_id'];
    $campaign;
    $amount = $row['amount_cents'];
    $since = $row['created_at'];
    $stopped = $row['deleted_at'];
    $amount = getInFullDollar($amount);
    $resultCamp = mysql_query("SELECT * FROM campaigns WHERE `campaign_id`='{$campaignID}'");
    $rowCamp = mysql_fetch_array($resultCamp);
    $campaign = $rowCamp['creation_name'];
    echo "<b>{$campaign}</b> (<a href='GetCampaign.php?campaignid={$campaignID}'>{$campaignID}</a>)<br/>With <b>\${$amount}</b> - Since: <b>{$since}</b> - Stopped: <b>{$stopped}</b><br/><br/>";
}
$total = 0;
//Second query, get campaign owner
$result = mysql_query("SELECT user_id FROM campaigns_users WHERE `campaign_id`='{$campaignid}'") or die(mysql_error());
$row = mysql_fetch_array($result);
$ownerID = $row['user_id'];
//Third query, get username
$result = mysql_query("SELECT * FROM tblUsers WHERE `UID`='{$ownerID}'") or die(mysql_error());
$row = mysql_fetch_array($result);
$owner = $row['FName'] . " " . $row['LName'];
//Echo information
echo "<img src='{$image}' /><br/>";
echo "<b>\"{$oneLiner}\"</b><br/></br>";
echo "<b>{$name}</b> by <b>{$owner}</b> (<a href='UserPortal.php?userid={$ownerID}'>{$ownerID}</a>) - Created: {$created} - Published: {$published}<br/><br/>";
echo "-------------------<br/><b>This campaign is supported by:</b><br/>-------------------<br/>";
$result = mysql_query("SELECT * FROM pledges WHERE `campaign_id` = '{$campaignid}' AND `deleted_at` IS NULL") or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
    $pledgeUser = $row['user_id'];
    $userFirstName;
    $userLastName;
    $amount = $row['amount_cents'];
    $since = $row['created_at'];
    $total += $amount;
    $amount = getInFullDollar($amount);
    $result2 = mysql_query("SELECT * FROM tblUsers WHERE `UID`='{$pledgeUser}'") or die(mysql_error());
    $row2 = mysql_fetch_array($result2);
    $userFirstName = $row2['FName'];
    $userLastName = $row2['LName'];
    echo "<b>{$userFirstName} {$userLastName}</b> (<a href='UserPortal.php?userid={$pledgeUser}'>{$pledgeUser}</a>)<br/>With <b>\${$amount}</b> - Since: <b>{$since}</b><br/><br/>";
}
$total = getInFullDollar($total);
echo "-------------------<br/><b>Total: \${$total}</b><br/>-------------------<br/>";