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 "

".$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; } } $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