Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Dec 2007
    Posts
    65
    Thanks
    1
    Thanked 0 Times in 0 Posts

    check array for blanks

    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

  • #2
    New Coder
    Join Date
    Feb 2009
    Location
    United States
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You've shown us no code, how are we supposed to fix what we can't see?

  • #3
    New Coder
    Join Date
    Dec 2007
    Posts
    65
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Infect View Post
    You've shown us no code, how are we supposed to fix what we can't see?
    Sorry, I was just asking in principle how you could do that with an array.
    My initial attempt but not finished:

    $query = "
    SELECT o.orders_id, o.orders_status, osh.comments
    FROM orders o
    INNER JOIN orders_status_history osh ON osh.orders_id = o.orders_id
    AND osh.orders_status_id =1
    AND o.orders_status =3
    ORDER BY o.orders_id DESC ";

    $result = mysql_query($query, $squid_conn_int) or die(mysql_error());

    $oid = 0;
    $arrToCheck = array();
    while ($squid = mysql_fetch_array($result, MYSQL_NUM) )
    {

    //echo "<tr>";
    //echo "<td>".$squid[0]."</td><td>".$squid[1]."</td><td>".$squid[2]."</td>";
    //echo "</tr>";
    //

    if ($oid != $squid[0]
    && $squid[2] == ""
    ) {
    $oid = $squid[0];
    //add into array
    $arrToCheck[] = $oid;
    }


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •