Stuff

function display_ebay_listings($ebay_listings) {
		if($ebay_listings) {
			$total_listing_fees_sold = 0;
			$total_listing_fees_ended = 0;
			$total_listings_ended = 0;
			$total_listings_sold = 0;
			$display = "<table class=\"ebay_listings_table\">";
			foreach($ebay_listings as $listing_period => $campaignes) {
				$display .= "<tr class=\"ebay_listings_time_header\"><td colspan=\"8\">".$listing_period."</td></tr>";
				if(is_array($campaignes)) {
					foreach($campaignes as $campaigne_id => $campaigne) {
						$display .= "<tr class=\"ebay_listings_campaigne_header\"><td colspan=\"8\">".$campaigne['title']."</td></tr>";
						if(is_array($campaigne)) {
							foreach($campaigne as $ebay_listing_id => $ebay_listing) {
								$display .= "<tr class=\"ebay_listings_details\">
											<td>".$ebay_listing['item_number']."</td>
											<td>".$ebay_listing['item_name']."</tD>
											<td>".$ebay_listing['listing_type']."</td>
											<td>".$ebay_listing['duration']."</td>
											<td>".$ebay_listing['price']."</td>
											<td>".$ebay_listing['ship_can']."</td>
											<td>".$ebay_listing['ship_us']."</td>
											<td>".$ebay_listing['status']."</td>
											</tr>";
							}
						}
					}
				}
			}
			$display .= "</table>";
		} else {
			$display = "No listings found!";
		}
		return $display;
	}
	function get_ebay_listings($query) {
		$get_listings = mysql_query($query, $this->conn) or die(mysql_error());
		if(mysql_num_rows($get_listings)) {
			$ebay_listings = array();
			while($listings = mysql_fetch_array($get_listings)) {
				$listing_id = $listings['ebay_listing_id'];
				$listing_period = date("d-m-Y", strtotime($listings['start_time']))."-".date("d-m-Y", strtotime($listings['end_time']));
				if($ebay_campaigne_id = $listings['ebay_campaigne_id']) {
					$get_campaigne = mysql_query("SELECT * FROM ebay_campaignes WHERE ebay_campaigne_id = '$ebay_campaigne_id'", $this->conn) or die(mysql_error());
					$ebay_campaigne = mysql_fetch_array($get_campaigne);
					$ebay_listings[$listing_period][$ebay_campaigne_id]['title'] = $ebay_campaigne['title'];
				} else {
					$ebay_campaigne_id = 0;
					$ebay_listings[$listing_period][$ebay_campaigne_id]['title'] = "No campaigne";
				}
				$ebay_listings[$listing_period][$ebay_campaigne_id][$listing_id] = array(
					'ebay_sku_id' => $listings['ebay_sku_id'],
					'extra_sku_id' => $listings['extra_sku_id'],
					'listing_type' => $listings['listing_type'],
					'item_number' => $listings['item_number'],
					'item_name' => $listings['item_name'],
					'duration' => $listings['duration'],
					'quantity' => $listings['quantity'],
					'price' => $listings['price'],
					'ship_can' => $listings['ship_can'],
					'ship_us' => $listings['ship_us'],
					'start_time' => $listings['start_time'],
					'end_time' => $listings['end_time'],
					'ended_time' => $listings['ended_time'],
					'listing_fees' => $listings['listing_fees'],
					'quantity_sold' => $listings['quantity_sold'],
					'revisions' => $listings['revisions'],
					'status' => $listings['status'],
					'relisted' => $listings['relisted'],
				);
			}
			return $ebay_listings;
		} else {
			return;
		}
	}