[RESOLVED] Checking an array.

[Siggles]

I have a mysql query that will return an array such as...

Delivered Not Needed
No Yes
Yes No

I need to display a tick image if....

all items are delivered (no need for php to also check if not needed here)
all items are delivered that are NOT also marked as not needed

I need to display a cross if....

any item in the array is marked as not delivered and Not needed is marked as No (ie the item is needed but not delievered).

The above example would need to display a tick as the first item was not needed by the customer.

Hope that makes sense.

I tried this but didnt get very far...

$query66 = mysql_query("SELECT Delivered, Notneeded FROM sales_items WHERE Tender = $sr_tender");
$row66 = mysql_fetch_array($query66);

if (!in_array("no", $row66)) { echo "<img src='tick.gif' width='15' height='15' />";  }

I also treid if else statements but it only checked the last entry in array.

Any better ideas?😃

[big_nerd]

Siggles,

When you use $row66 = mysql_fetch_array() there are 2 problems:

1. When using this, you are only returning the LAST item from MySQL
2. You are wasting memory, as you are going to have double the elements as mysql_fetch_array without parameters gives you both array styles (numeric & associative)

i.e.

$row66 Array([0] => No, [Notneeded] => No);

That being said, give the following a try:

<?php
$query66 = mysql_query("SELECT Delivered, Notneeded FROM sales_items WHERE Tender = $sr_tender");
//$row66 = mysql_fetch_assoc($query66); // you are only getting 

while ($row = mysql_fetch_assoc($query66) {
  //if (!in_array("no", $row)) { echo "<img src='tick.gif' width='15' height='15' />";  }
  if ($row['Delivered'] == 'no' && $row['Notneeded'] == 'no') {
    echo "<img src='tick.gif' width='15' height='15' />";    

  } elseif ($row['Delivered'] == 'yes') {  

    echo "<img src='tick.gif' width='15' height='15' />";
  } else {
    // Delivered is no, but 'notneeded' is yes.
    // do whatever you want
  }
  echo "<br />"; // optional -- just so it goes down

}

?>

This will allow you to call the row names (as specified in your SQL statement) as well as iterate through all of the results.

Let me know if this helps...

[Siggles]

I ended up doing this which worked pretty well...

$countera = 0;
$query55 = mysql_query("SELECT Invoicercd, Notneeded FROM sales_items WHERE Tender = $sr_tender ");
while($row55 = mysql_fetch_array($query55)) {
if (($row55['Invoicercd'] == 'no') && ($row55['Notneeded'] == '0')) {
	$countera = $countera + 1;
	}
}

if ($countera > 0) { echo "<img src='cross.gif' width='15' height='15' />"; }
else { echo "<img src='tick.gif' width='15' height='15' />"; }
$countera = 0;