simonp

I want to add another item to the order_lines array but however I do it I end up with an error: $data = [ 'purchase_country'=>$company_country, 'purchase_currency'=>$currency_nm, 'order_amount'=>$api_amount, 'locale'=>"en-GB", 'order_tax_amount'=>0, 'order_lines'=>[ [ 'name'=>$product_name, 'quantity'=>1, 'unit_price'=>$api_amount, 'tax_rate'=>0, 'total_amount'=>$api_amount, 'total_tax_amount'=>0 ] ], "intent"=>"buy" ]; I thought this would work: 'order_lines'=>[ [ 'name'=>$product_name, 'quantity'=>1, 'unit_price'=>$api_amount, 'tax_rate'=>0, 'total_amount'=>$api_amount, 'total_tax_amount'=>0 ], [ 'name'=>$product_name2, 'quantity'=>1, 'unit_price'=>$api_amount2, 'tax_rate'=>0, 'total_amount'=>$api_amount2, 'total_tax_amount'=>0 ] ], "intent"=>"buy" ]; Any ideas please? Thanks!

Thanks so much Barand - that works a treat. Would never have worked it out myself Cheers

Hi gents, Thanks so much for your replies but sadly that doesn't work as it gives me everyone who is a Member of group 7 OR group 8 and I need to know who is in both group 7 AND group 8 (many people have multiple roles). Any ideas? Cheers

Hello, We have a (complicated!) Drupal database in which users can be assigned multiple roles (member, leader, coordinator, etc) I have a query to get info about all our members (users_roles.rid = 7) but I need to get a list of people who are members AND leaders (users_roles.rid = 8 ) but this doesn't work: SELECT users.uid, users.`name`, users.mail, users.created, users_roles.rid, field_data_field_first_name.field_first_name_value, field_data_node_venue_region.node_venue_region_tid FROM users INNER JOIN users_roles ON users.uid = users_roles.uid INNER JOIN field_data_field_first_name ON field_data_field_first_name.entity_id = users.uid INNER JOIN field_data_node_venue_region ON field_data_node_venue_region.entity_id = users.uid WHERE users_roles.rid = 7 and users_roles.rid = 8 Any advice appreciated! Thanks.