I have data as below.
I can't do this check in the SQL because my server is still on v 4 so I have to do it in PHP code.
If there is a blank line linked to an order ID but that orderID also has a PayPal entry then it's ok, I want to delete it from the array.
However, if it hast an OrderID and everything is blank, then I want to echo it.
In the example below:
9502 is incorrect
9503 only has 1 row but is ok
the rest may have 2 or more rows but as long as 1 row has PayPal in it, then it is ok.
How can I loop through an array but then delete everything from the array with that ID, and then carry on looping through the array again?
Code:
9511 3 PayPal IPN Verified [Completed (Verified; £24.99)]
9511 3
9508 3 PayPal IPN Verified [Completed (Unverified; £3.99)]
9508 3
9507 3 PayPal IPN Verified [Completed (Unverified; £1.99)]
9507 3
9506 3 PayPal IPN Verified [Completed (Verified; £9.49)]
9505 3 PayPal IPN Verified [Completed (Verified; £9.49)]
9505 3
9504 3 PayPal IPN Verified [Completed (Verified; £7.99)]
9504 3
9503 3 PayPal IPN Verified [Completed (Unverified; £7.99)]
9502 3
9502 3