Anonymous

function get_ebay_listings($query) {
		echo $query;
		$get_listings = mysql_query($query, $this->conn) or die(mysql_error());
		if($listings_num = mysql_num_rows($get_listings)) {
			echo "<BR><BR>".$listings_num;
			$ebay_listings = array();
			while($listings = mysql_fetch_array($get_listings)) {
				$listing_id = $listings['ebay_listing_id'];
				$listing_period = date("D, M d", strtotime($listings['start_time']))." - ".date("D, M d", strtotime($listings['end_time']));
				$ebay_listings[$listing_period][$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;
		}
	}
	
	if(isset($_POST['day1']) && isset($_POST['month1']) && isset($_POST['year1']) && isset($_POST['day2']) && isset($_POST['month2']) && isset($_POST['year2'])) {
		$day1 = $_POST['day1'];
		$month1 = $_POST['month1'];
		$year1 = $_POST['year1'];
		$day2 = $_POST['day2'];
		$month2 = $_POST['month2'];
		$year2 = $_POST['year2'];
	} else {
		$day1 = date("d", time()-(86400*7));;
		$month1 = date("m", time()-(86400*7));;
		$year1 = date("Y", time()-(86400*7));;
		$day2 = date("d");
		$month2 = date("m");
		$year2 = date("Y");
	}
	$query = "SELECT extra_skus.*, ebay_listings.* FROM ebay_listings INNER JOIN extra_skus ON ebay_listings.extra_sku_id = extra_skus.extra_sku_id WHERE ebay_listings.end_time >= '$year1-$month1-$day1' && ebay_listings.end_time <= '$year2-$month2-$day2' ORDER BY ebay_listings.end_time, extra_skus.title";
	$ebay_listings_arr = get_ebay_listings($query);
	
	// $ebay_listings_arr is always 0!
	// BUT $query works in SQL