Order table export sql error

Code: Select all

protected function getOrders( &$languages, $offset=null, $rows=null, $min_id=null, $max_id=null ) {
		$sql  = "SELECT ";
		$sql .= "  o.order_id,";
		$sql .= "  o.invoice_no,";
		$sql .= "  o.shipping_address_2,";
		$sql .= "  o.shipping_country,";
		$sql .= "  o.shipping_zone,";
		$sql .= "  o.shipping_method,";
		$sql .= "  o.comment,";
		$sql .= "  o.order_status_id,";
		$sql .= "  o.affiliate_id,";
		$sql .= "  o.commission,";
		$sql .= "  o.language_id,";
		$sql .= "  o.accept_language,";
		$sql .= "  o.date_added, ";
		$sql .= "FROM `".DB_PREFIX."order` o ";
	if (isset($min_id) && isset($max_id)) {
			$sql .= "WHERE o.order_id BETWEEN $min_id AND $max_id ";
	}
		$sql .= "GROUP BY o.order_id ";
		$sql .= "ORDER BY o.order_id ASC ";
		if (isset($offset) && isset($rows)) {
			$sql .= "LIMIT $offset,$rows; ";
		} else {
			$sql .= "; ";
		}

        $results = $this->db->query( $sql );
		return $results->rows;
	}

Code: Select all

 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `oc_order` o GROUP BY o.order_id ORDER BY o.order_id ASC' at line 1
Error No: 1064

Code: Select all

protected function getOrders( &$languages, $offset=null, $rows=null, $min_id=null, $max_id=null ) {
	$sql = "SELECT `o`.`order_id`, `o`.`invoice_no`, `o`.`shipping_address_2`, `o`.`shipping_country`, `o`.`shipping_zone`, `o`.`shipping_method`, `o`.`comment`, `o`.`order_status_id`, `o`.`affiliate_id`, `o`.`commission`, `o`.`language_id`, `o`.`accept_language`, `o`.`date_added` FROM `" . DB_PREFIX . "order` `o`";
	
	if (isset($min_id) && isset($max_id)) {
			$sql .= "WHERE `o`.`order_id` BETWEEN " . (int)$min_id . " AND " . (int)$max_id;
	}
	
	$sql .= "GROUP BY `o`.`order_id` ";
	
	$sql .= "ORDER BY `o`.`order_id` ASC ";
	
	if (!empty($offset) && !empty($rows)) {
		$sql .= "LIMIT $offset,$rows; ";
	} else {
		$sql .= "; ";
	}

    $results = $this->db->query($sql);
	
	return $results->rows;
}

Code: Select all

 if (isset($min_id) && isset($max_id)) {
 $sql .= "WHERE o.order_id BETWEEN $min_id AND $max_id ";
 } else {
 $sql .= "WHERE o.order_id > '0'";
 }

Code: Select all

 $sql .= "WHERE o.order_id > '0'";

Code: Select all

     if (isset($min_id) && isset($max_id)) {
     $sql .= "WHERE o.order_id BETWEEN " . $min_id . " AND " . $max_id;
     } else {
     $sql .= "WHERE o.order_id > '0'";
     }

Code: Select all

      if (isset($offset) && isset($rows)) {
         $sql .= "LIMIT " . $offset,$rows;
      }