Advertisement
wclovers

Untitled

Jul 14th, 2023 (edited)
994
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.30 KB | None | 0 0
  1. global $wpdb;
  2.  
  3. $sql = "SELECT order_id FROM {$wpdb->prefix}wcfm_marketplace_orders";
  4. $sql .= " WHERE 1=1";
  5. $sql .= " AND vendor_id = %d";
  6. $sql .= " GROUP BY order_id";
  7. $number_of_orders = count( $wpdb->get_results( $wpdb->prepare( $sql, $supplier_id ) ) );
  8.  
  9. echo "(".$number_of_orders." Sales)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement