...

View Full Version : check array for blanks



qwertyjjj
11-05-2012, 05:11 PM
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?



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

Infect
11-06-2012, 06:04 AM
You've shown us no code, how are we supposed to fix what we can't see?

qwertyjjj
11-06-2012, 07:42 AM
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;
}



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum