Code: Select all
$sql = "SELECT * FROM `" . DB_PREFIX . "order` WHERE 1 = 1";
$sql = "SELECT * FROM " . DB_PREFIX . "order o LEFT JOIN " . DB_PREFIX . "customer c ON (o.customer_id = c.customer_id) WHERE 1 = 1";
if(isset($filter_sql)){
$sql .= " AND ".implode(" AND ",$filter_sql);
}
/* customergroup1 id: = 1
customergroup1 order status: 1 , 3 , 18 */
/* customergroup2 id: = 5
customergroup2 order status: 20 , 22 , 23 , 24 */
$sql .= " AND o.customer_group_id = '5'"; (i want to add the id = 1 too, whats the right syntax?)
$sql .= " AND order_status_id IN ('1','3','18','20','22','23','24')";