$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/>";